Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Parse JSON String in column

Hi, How is possible to parse JSON string in the column to several columns?  
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

You should be able to use the Json.Document function to parse the JSON.  Depending on the structure, you will likely be able to expand the contained Records and/or Lists.

Regards,

Pat