Transform selected excel columns to json string in data factory v2

0
votes

I am having the excel sheet with multiple columns. I need to transform selected column of excel sheet to json string and store in seperate column in excel using Azure Data Factory V2.

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 or I have to use custom activity to achieve the format.

1
jsonazure-data-factoryazure-data-factory-2azure-data-flow
Hi @user1696555, did my answer meet your request? If my answer is helpful for you, hope you can accept it as answer. This can be beneficial to other community members. Thank you. - Leon Yue

1 Answers

0
votes

Yes, Data Flow could make it as a JSON string. But it's not a real JSON object.

You could try bellow expressions:

concat('[{"',Column2,'":',Column3,'}]' )

enter image description here