Convert a Json List into a table and add further columns

[Anonymous]

Hi,

I have a Json file that I have unpacked which has given me a table containing some flat values and some colums containing multiple values held as a Json list.

I would like to extract the column containing the multiple values into a new table but also take the Id colum of the table to act as a key back to the original table.

The table looks a little like this:

Table A

Id	Countries
1	List
2	List

And what I'd like to achieve is this:

Table B

Table A.Id	Country
1	USA
1	France
2	Great Britain
2	Germany
2	Italy

Any help would be greatly appreciated!

[MFelix]

Hi @Anonymous ,

On the top of the query editor you should have a convert to table button, click next on the list values you should have to arrows if you click that you will get the expand values and the necessary result.

Follow the image below: