topic How to load JSON data held in a TXT file please? [Example provided] in QlikView https://community.qlik.com/t5/QlikView/How-to-load-JSON-data-held-in-a-TXT-file-please-Example-provided/m-p/1409858#M611470 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have a text file where the data is in JSON format.</P><P></P><P>The data looks like this:</P><P></P><P><SPAN style="color: #993366;">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}</SPAN></P><P></P><P>The "JSON FILE - DATA GENERATION" is included in the file.</P><P></P><P>How can I load this into Qlik(View or Sense) please?</P></BODY></HTML> Fri, 03 Nov 2017 15:06:03 GMT jblomqvist 2017-11-03T15:06:03Z How to load JSON data held in a TXT file please? [Example provided] https://community.qlik.com/t5/QlikView/How-to-load-JSON-data-held-in-a-TXT-file-please-Example-provided/m-p/1409858#M611470 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have a text file where the data is in JSON format.</P><P></P><P>The data looks like this:</P><P></P><P><SPAN style="color: #993366;">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}</SPAN></P><P></P><P>The "JSON FILE - DATA GENERATION" is included in the file.</P><P></P><P>How can I load this into Qlik(View or Sense) please?</P></BODY></HTML> Fri, 03 Nov 2017 15:06:03 GMT https://community.qlik.com/t5/QlikView/How-to-load-JSON-data-held-in-a-TXT-file-please-Example-provided/m-p/1409858#M611470 jblomqvist 2017-11-03T15:06:03Z