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

[jblomqvist]

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.

[petter]

You're right Rob. I stumbled over it by chance. If I remember correctly I brought the executable file of Qlik Sense up in a text editor - I think it was Notepad++ to have a look at the list of keywords that might be supported. And surprisingly I found a BNF that showed me the parsing of scripts embedded in the executable. By reading this I discovered the json as a valid format-spec. This was almost a year ago I believe. I confirmed with some other guy that knows the actual code within Qlik Sense that indeed it is supported - in the code.

It has not yet materialized into the documentation. One probable reason for that is that it has a serious limitations when it comes to hierarchical or nested JSON. It doesn't do it. So it is only useful in it's simple use to parse flat JSON-files. It works for both QlikView and Qlik Sense.

No - I didn't find any other undocumented format-spec things apart from json...

-Petter