Forum Discussion
PhotDude52
Dec 13, 2021Copper Contributor
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...
- Dec 13, 2021
PhotDude52
Dec 13, 2021Copper Contributor
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
Dec 13, 2021Diamond Contributor
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.
- PhotDude52Dec 13, 2021Copper ContributorThanks again!