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 ...
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
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 Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.