Forum Discussion

Copper Contributor

Dec 13, 2021

Solved

Converting a Json file and data into a Table

I'm trying to convert a Json file into a query and table. It seems that the process works fine until I get to the "record" column and find no "list" heading or means to select every record in the lis...

excel

SergeiBaklan
Dec 13, 2021
PhotDude52

You may transform list into the table and after that expand records

SergeiBaklan

Diamond Contributor

Dec 13, 2021

PhotDude52

You may transform list into the table and after that expand records

PhotDude52

Copper Contributor

Dec 13, 2021

SergeiBaklan

I must be slow. I'm at the screen as shown in your reply, but after turning it into a table, how do I see the actual record entries? I only see a "close and load" option

SergeiBaklan
Diamond Contributor
Dec 13, 2021
PhotDude52

After transforming to the table on column with records it shall be icon like this

with which you may expand records.
- PhotDude52
  Copper Contributor
  Dec 13, 2021
  SergeiBaklan
  
  Thanks so much for the instructions. I fumbled around with a bit (based on a video from and older release), but was ultimately able to get there with you help. I'mn ot a complete novice with applications like this and I don't think it's the instinctive setup. Anyway...thanks!
  - SergeiBaklan
    Diamond Contributor
    Dec 13, 2021
    PhotDude52 Glad it helped
    
    There is no such button which transforms json to table at once, if only very simple json file. You need to do transformations step by step, usually there are nested records and lists which we shall expand and transform.