i am getting data in the below format.
how do I transpose to get it in the below format ??
Solved! Go to Solution.
@mceleavey Thanks a lot. I added an extra record to the sample data and columns got overlapped. This is exactly I am experiencing with real data. Attaching sample data. Hope there is a way to fix this.
Hi @geeksqaud ,
Yes, this is because you have different formats within your json structure.
This is unfortunately common.
As you can see, I've split the streams into the two different formats (number of sections in the JSON Name field) and handled them independently.
I then joined them back on the key ID field.
Hope this helps,
M.