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?
I tried doing this but the arrays are not being exploded. Could you please explain me more?
Deep traversal will apply to your structures, but the arrays will still need to be unrolled.
I tried that but it is giving me a error saying "The array you're referring to is not present"
Hey, is there any update on this. Can we unroll this type of data or not?
Hi Can you please let me how arrays can be unrolled further
Hi In my xml document i have more than 30 array in this case i have to use 30 flatten with each array?Can you please help me in this how can unroll?
@MarkKromer-MSFT
Hi Dinesh, is this problem solved ? I am also facing same issue.
Sign in to comment