This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 21%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
I have JSON data source which need to be transformed into CSV structure and store into a blob storage.
I have below structure as of now
ReleaseCod
[{"PCod":"P-","ActualDate":"2021-12-03","PlannedDate":null,"ReminderDate":null,"ActualBy":"LIWA"},
{"PCod":"R-","ActualDate":"2021-12-30","PlannedDate":null,"ReminderDate":null,"ActualBy":"LIWA"}]
Required structure as below
PCod ActualDate
P- 2021-12-03
R- 2021-12-30
Few things need to mention here not able to use flatten transformation as ReleaseCod having some complex structure and as well as non complex structure in same file.
So any way to achieve above mentioned structure as CSV output file?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Thanks for using Microsoft Q&A platform to post your query.
You can make use of flatten transformation even if you have a complex array in your json source.
in cast you have any errors using the same , please post it here with more details on the error.
Here is a sample video to load json file for your reference.
Thank you
Hello Subashri,
Thanks for the suggestion.
Basically i have complex type of structure in my source JSON and unable to select the same as flatten support array type structure only.
Could you please share alternate way if any?
Hi @Abhijit Bhadra ,
Not sure how complex your source is. Please see some suggestions here from MSFTs in the SO portal. Kindly check and let us know if that helps.
Thanks.
First use the Flatten transformation to unroll your top-level array. Then you'll end up with just a hierarchical structure: {"PCod":"P-","ActualDate":"2021-12-03","PlannedDate":null,"ReminderDate":null,"ActualBy":"LIWA"}.
Now you can use a Derived Column to define new columns, i.e. "PCod", "ActualDate", ...
Hello Mark,
Could you please share an example of derived column transformation part as unrolling top level array already applied
In this example, I have created a new column in my data flow's metadata called "MyProductName". It will take the value from the Product hierarchical structure, which I previously unrolled from an array.
