ADF Dataflows flatten a JSON using unroll by not working.

Question

Hi

I have a JSON like this in my file and i am trying t flatten it using the flatten transformation in dataflow. when i click on unroll by all the elements are displayed but i am unable to select any..

how can i do that .? or is there any other way i can flatten it.?

{"data":{"authenticate":{"catsObj":{"pageInfo":{"totalCount":16279}}}}}

Answer 1

Hi @Tarapareddy,Saikrishna ,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

The reason you are not able to select any object/element in Unroll by property is because your source sample doesn't have any array objects.

Please feel free play around with the sample provided in the public documentation to get better understanding of the flatter transformation usage. The documentations also contain data flow script which you can copy past and modify accordingly to test the sample provided. It also contains a video demonstration from product team which will be very helpful.

Since your source only has json object and not an array object, and if you would like to access the value of totalCount then you can use select transformation to get the value as shown below.

Hope this info helps.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.