Forum Discussion
expand column with json content
Hi , I have a SQL table with columns and one of the columns contain a json string. I would like to have a flat table ie to expand the column, however the json varies from field to field. ...
MarkLaf
Super User
Super UserAdd a custom column and enter the following:
Json.Document([metadata])
If you are worried about errors (e.g. from instances of [] etc.), you can use the following:
try Json.Document([metadata]) otherwise null
The resulting custom column can be expanded.