How to fix Null arrays in JSON denormalization in azure data flow during multiple flatten activities

Phani 0 Reputation points

I am flattening a JSON file having several arrays.

I can flatten one array in the first flatten activity by using "unroll by".

Now it gives me 5 records from the first array.

Again I want to flatten second activity, this time the array is having 0 rows. Now if I flatten the empty array, the output is shown as "NO output data" in Azure dataflow.

I don't have previous 5 records too to carry my next flatten activity. How to solve this problem.

Please help if you have a solution.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,135 questions
{count} votes