CODEWITHSUNDEEP
datasetazure-data-factory
Nezko1
Nezko1

Reputation: 25

How To read a column which has indentations in its name in dataflow ADF

enter image description hereI am having trouble using the source column in the Derived Column stage of my Data Flow. The column names in my source file are as follows:

employee employee employee name mobile joining number date

Is there any way to use these columns in the Data Flow? I am receiving an error when attempting to use them in the Derived Column stage. Please advise.

Upvotes: 0

Views: 106

Answers (1)

Aswin
Aswin

Reputation: 7156

I tried to replicate this with column name with \n and got the error like Column not found

enter image description here

Workaround: If you know the position of the column, you can use the byPosition(<position>) function.

enter image description here

Output

enter image description here

Upvotes: 0

Related Questions