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

Dinesh Kakumanu 11 Reputation points


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?





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

1 answer

Sort by: Most helpful
  1. MarkKromer-MSFT 5,166 Reputation points Microsoft Employee

    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".