Share via

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.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MarkKromer-MSFT 5,231 Reputation points Microsoft Employee Moderator
    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".

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.