Flatten Transformation in Mapping Data Flow | Azure Data Factory Tutorial | Beginner Level

Use the flatten transformation to take array values inside hierarchical structures such as JSON and unroll them into individual rows. This process is known as denormalization.

Unroll by
Select an array to unroll. The output data will have one row per item in each array. If the unroll by array in the input row is null or empty, there will be one output row with unrolled values as null.

Unroll root
By default, the flatten transformation unrolls an array to the top of the hierarchy it exists in. You can optionally select an array as your unroll root. The unroll root must be an array of complex objects that either is or contains the unroll by array. If an unroll root is selected, the output data will contain at least one row per items in the unroll root. If the input row doesn't have any items in the unroll root, it will be dropped from the output data. Choosing an unroll root will always output a less than or equal number of rows than the default behavior.

#flatten #flattenTransformation #azure #azuredatafactory #azuretutorials #beginnertutorial #cloudknowledge #json #workwithjson #convertarray

[ravireddy]

I have 243 tables, after copying 128 tables the pipeline has faliled, can you provide the solution for these scenario

[dileeprajnarayanthumula]

Could you please Flatten XML with ADF Data Flow