Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,135 questions
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.
{count} votes
-
KranthiPakala-MSFT 38,597 Reputation points Microsoft Employee
2023-05-02T21:42:37.9033333+00:00 Hi @Phani ,
Thanks for using Microsoft Q&A forum and posting your query.
To better assist on this requirement, could you please help share a sample source data file with dummy data so that we better understand the problem. In addition kindly share few screenshots of your data that has been configured and where you have been stuck.
Thank you
-
KranthiPakala-MSFT 38,597 Reputation points Microsoft Employee
2023-05-03T23:40:10.5933333+00:00 @Phani Checking to see if you have got a chance to see my previous response. If so, kindly share the requested information so that we can assist you accordingly.
Thank you
Sign in to comment