Schema drift not working for unpivot transformation

Question

Hi,

I'm trying to use "Unpivot" transformation on a Source that don't have schema pre-defined (Schema Drift is activated).
The "unpivot" transformation generates the following error:

UngroupBy does not allow expressions or column assignments

i tired both byname and columns on the expression both given same error.

Please any help me out

Thanks in advance

Answer 1

Hi @Arunkumar ,

Thanks for posting query in Microsoft Q&A Platform.

Dynamic expression in Unpviot transformation for Ungroup by will not works. Hence we should consider a workaround of define a dynamic column using byName() in the Derived Column, assign it a synthetic column name like "MyUngroupColumn". Use this column which we created in ungroup by of Unpivot transformation.

Kindly check below video to get idea about Unpivot transformation that how it works.
Unpivot Transformation in Mapping Data Flow in Azure Data Factory

Hope this helps. Please let us know how it goes.

-----------

Please consider hitting Accept Answer. Accepted answers help community as well.