Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to load JSON data held in a TXT file please? [Example provided]

Hello all,

I have a text file where the data is in JSON format.

The data looks like this:

JSON FILE - DATA GENERATION [{"call_id":"1123335900-1496666340000-3","Region":"North America","user_id":5893,"call_reason":"[50]","call_source":"Internet","call_time":254.8,"customer_type":"General","q_score":98,"unix":997765577}

The "JSON FILE - DATA GENERATION" is included in the file.

How can I load this into Qlik(View or Sense) please?