I have a Country column in JSON format in spotfire and want to convert it into a tabular format. How can I convert the Json format to a table format

[Evangelina Jacob]

I have a Country column in JSON format in spotfire and want to convert it into a tabular format. How can I convert the Json format to a table format. note we have multiple entries of each country in the country column

[David Boot-Olazabal]

Hi Evangelina,

 

I have found this post which could be a starting point for you:https://community.spotfire.com/wiki/how-convert-json-csv-tibco-spotfirer-us....

I also have attached an example dxp, in which I use an iron pythn script to load json data.

Kind regards,

David