Forum Discussion

PhotDude52's avatar
PhotDude52
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 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

    • PhotDude52's avatar
      PhotDude52
      Copper Contributor

      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's avatar
        SergeiBaklan
        Diamond Contributor

        PhotDude52 

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

        with which you may expand records. 

Resources