Expand values of a JSON with a mix of records and lists

[raymond]

Hello everyone,

I have some trouble with a JSON file. After opening it and expanding the row with record items (see Image A) I received another column with a mix of records and lists (see Image B). However I couldnt manage to open them ALL at once. Of course I can expand one item but I need all the items.

Image AImage B

[raymond]

@Vera_33 : That worked.

It resulted in a couple of extra steps and finally merging all expanded columns together 🙂

[Vera_33 · Accepted solution]

Hi @raymond 

It depends on the data in list and record, add another column, try Record.ToList otherwise thiscolumn, or check the type if type is list then actionA else actionB