dataflow - flatten json file data

Question

Hello,
I have a complicated json file which has multiple hierarchies within hierarchies.
Is there an example link which helps me flatten a COMPLEX (multi level hierarchies) json file?

Thank you

Answer 1

Hi @arkiboys ,

Thank you for posting query in Microsoft Q&A Platform.

To summarize ask here, you are looking to flatten json file data which has multiple hierarchies. Please correct me if I am wrong.

Flatten transformation helps to flatten json data in data flows. Click here to know more about flatten transformation.

Below are few videos which I found to explain how flatten transformation helps to flatten data.

• Flatten Transformation in Mapping Data Flow in Azure Data Factory
• How to Read JSON File with Multiple Arrays By using Flatten Activity

When we have multiple levels of hierarchies we should consider using multiple flatten transformations to transform data.

Hope this helps. If still its not clear, feel free to share sample json of yours, so that We can share sample implementation. Thank you.

-------------

Please consider hitting Accept Answer. Accepted answers helps community as well.