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

asked 2022-06-16T12:01:38.427+00:00
RCHEST 41 Reputation points

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,262 questions
No comments
{count} votes

Accepted answer
  1. answered 2022-06-17T10:36:16.89+00:00
    ShaikMaheer-MSFT 28,096 Reputation points Microsoft Employee

    Hi @RCHEST ,

    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.

    No comments

0 additional answers

Sort by: Most helpful