Forum Discussion
Anonymous
5 years agoNot applicable
Parse JSON String in column
Hi, How is possible to parse JSON string in the column to several columns?
Jimmy801
5 years agoCommunity Champion
Hello Anonymous
you can use Table.TransformColumns or even better Table.TransformRows to loop through your data and applying a Json.Document on every cell. Surround it by try otherwise to handle empty rows or non-json-cells
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy