Extracting a JSON file into Qliksense

[robzagey1]

Hi Everyone,

I am extracting JSON files from Amazon S3 into Qliksense which works perfectly. 

The Json file has a nested data structure(field hierachy/fields within fields) on the eventData field as per below which can also change depending on the json. How do I extract the nested columns? 

I am using the S3 and Rest connector in sense to extract the data and loading it into a table using a SQL script. 

{

  "eventSource": "ChatBot",

  "eventDate": "2020-10-12T12:32:32.117",

  "eventName": "statement-success",

  "eventCategory": "statements",

  "eventData": {

    "entityNumber": "",

    "idNumber": "861203588"

  },

  "eventDuration": 0

}

[Brett_Bleess]

@robzagey1 Have a look at the following Design Blog post, I believe it may help you with your use case:

https://community.qlik.com/t5/Qlik-Design-Blog/Bit-operators-How-to-operate-with-multiple-values-sto...

Regards,
Brett