Forum Discussion
How do I unpivot with schema drift enabled?
I have a source without a pre-defined schema. I derive each column name using a column pattern expression: Data preview shows what I expect (which is a file in a blob container): I then hav...
What if you try to use a derived column instead of select for the renaming?
In that case you're not renaming the existing column but create a new column based on the existing using the expression Marker_name22 = byName('Marker name')
A guess that the select transformation explicitly defines the schema by specifying which columns to include and what their names are so overriding schema drift setting.