Forum Discussion
Rows to Columns - Unnest Nested JSONs
Hello Friends
May i Have some Help?
I have nested JSON files, im trying to transform Rows -> Column to unnest the table again
Here is a pic:
https://i.ibb.co/MPyFgjv/unnest.jpg
Any tip? 😕
2 Replies
- xinxilasFrequent Visitor
I tried to Pivot Columns(atributes id as Column, and atributes names as values), but i recieve this error:
https://i.ibb.co/3THNFgW/image.png
- daxCommunity Support
Hi xinxilas,
It seems that the operator can't work on List, you might need to modify it. But I couldn't know, what expression you use in M code cause thie problem, so if possible, could you please inform me more details information(such as your sample code and your expected output)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.