How to flatten multiple arrays in an XML document using dataflows?

Dinesh Kakumanu 11 Reputation points
2021-07-07T11:02:14.073+00:00

Hi,

I have multiple complex arrays and nested objects in my XML document but through dataflows I'm not able to flatten all the columns using flatten activity. I tried using multiple flatten activities but it is overwriting the previous mappings.

I have attached a sample XML document and the approach I tried in the attached images. Is there any way to achieve clean flattening of all my columns in the sample file using data factory?

@MartinJaffer-MSFT

112507-sample.xml

112527-image.png

112518-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,464 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MarkKromer-MSFT 5,186 Reputation points Microsoft Employee
    2021-07-07T16:31:27.37+00:00

    If you have multiple array types inside of your top-level array that you unroll in Flatten, use the Rule-Based mapping option instead and select "Deep column traversal".