CODEWITHSUNDEEP
jsonazureazure-data-factory
user1696555
user1696555

Reputation: 93

Concat multiple columns to single columns with columname and values in Data Factory V2 Data Flow

I need to concatenate selected column of excel sheet in seperate column using Azure Data Factory V2 data flow.

In data factory v2 using data flow we can create and update the existing columns using Derived Column Transformation.

I am having below excel file:

enter image description here

With Azure Data Factory data flow, I need to transform the file to below:

enter image description here

Please let me know if this is possible to achieve in Derived Columns data flow transformation

Upvotes: 0

Views: 2037

Answers (1)

Mark Kromer MSFT
Mark Kromer MSFT

Reputation: 3838

You'll create E as a struct in a Derived Column. Create a new column in the Derived Column called "E" and then add 2 subcolumns. Assign the incoming field "C" to the new subcolumn C and incoming "D" to the subcolumn D.

enter image description here

Example video walk-thru: https://www.youtube.com/watch?v=oAEh21NFgWQ

Upvotes: 0

Related Questions