Load statement for a complex, nested JSON-file

[der_buschdoktor]

Hi ev'ryone,

I'm trying to create a load statement for a json file for the first time in Qlik Sense and ask for your help.
The structure of the json file looks like this:

{
field1:value,
field2:value,
field3:{subfield1:value,
           subfield2:value},
field4:value,
field5:[
           {subfield_a:value,
            subfield_b:value},
           {subfield_a:another value,
            subfield_b:another value}
          ],
field6
}

I would appreciate any help you can offer to create a working load statement.

Thank you 🙂

[NoNameFound]

Are you trying to load directly from a file or do you receive the data through the REST connector? 

[rafaelencinas]

Hi! 

If you are in Qlik Cloud Environment, JSON files are fully supported.

If you are in Qlik Desktop May 2025 patch 1 , its fully supported too.

It makes your work easier !

Bye!

[der_buschdoktor]

directly from a file

[der_buschdoktor]

Hi, we're still on November '24, Patch 8.

[NoNameFound · Accepted solution]

Hi Buschdoktor, 

you might want to consider upgrading to May 2025, works quite well in the load editor. 
See here on how to load json data from a file: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/working-with-J... 

I know it says Qlik Cloud, but it works on premise now, too.

Below I've attached an arbitrary demo file and a screen-cap of how it is loaded in the load editor. 

When loading like this, Qlik automatically splits nested data into its own table and connects it to the rest of the data through a hash used as a key. 

[der_buschdoktor]

Thanks for your advice. We will uipdate Qlik Sense next week.