Azure Data Factory - Data Flow - Derived Column Issue

0
votes

Am using Azure DataFlow - DerivedColumn to create some new columns.

Ex:

enter image description here

this is my source and can preview the data.

But from DerivedColumn1 i cannot see these column or even in Expression Editor

enter image description here

Expression Editor:

enter image description here

Is something changed in ADF or am I doing something wrong.

1
azure-data-factoryazure-data-factory-2azure-data-flow
How about delete the Derived Column and add again?Just from your screen, please set the first row as header in excel dataaset. – Leon Yue
Some other solution is create a new data flow. It may be a bug. – Leon Yue
Hi @Sreedhad, is the error solved now? – Leon Yue

1 Answers

0
votes

According you screenshot, the column name is set as the row. Or you will get the error in Sink column mapping. Please set "first row as header" in the excel dataset. enter image description here

If you don't check it, the column name will be considered as first row: enter image description here

For your issue, you could try bellow workarounds:

  1. import the source schema in Projection and Delete the Derived column active and add again.
  2. Drop the data flow and create a new one. Some time data flow may have bugs, we refresh the browser or just recreate the data flow, it will be solved.