how to map XML Source to JSON Sink and get a new column that contains data from 2 fields

Question

how to map XML Source to JSON Sink and get a new column that contains data from 2 fields

Answer 1

Hi @Anonymous ,

Thanks for posting query in Microsoft Q&A Platform.

So, here you are basically trying to combine two columns as one column using Azure data factory.

You should consider using data flows and use derived column transformation in it to achieve same.

When creating a derived column, you can either generate a new column or update an existing one. Click here to know more about how to create a new column or update an existing column using derived column transformation.

Below video also helps you to understand derived column transformation.
Derived Column Transformation in Mapping Data Flow in Azure Data Factory

In your case you should use XML format type dataset in source transformation and Json format type dataset in Sink transformation.

Hope this helps. Please let us know if any further queries.

---------------

Please consider hitting Accept Answer button. Accepted answers help community as well.