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".
How to flatten multiple arrays in an XML document using dataflows?
Dinesh Kakumanu
11
Reputation points
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?