Forum Discussion
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 list for conversion. Is there something I'm missing. As you can see from the screenshots, there are three selection options. the one that seems to contain the sought after data is the "gallery record". After selecting it and the vertical column appears, there is no "list" heading or way to select all the records for conversion to a table. The "list' option shown contains nothing but the numeric "ID"...none of the associated data that I require. Any help would be a greatly appreciated
6 Replies
- SergeiBaklanDiamond Contributor
- PhotDude52Copper Contributor
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
- SergeiBaklanDiamond Contributor
After transforming to the table on column with records it shall be icon like this
with which you may expand records.