JSON question

parpatra — Wed, 10 Jun 2015 16:59:47 GMT

am trying to load a JSON file using the steps as mentioned by Frank. But I am not able to load that in qlikview. It reads the data in first step, but errors out when loading the second step as 'cannot read tmp'.

file source (see attached city data)

http://78.46.48.103/sample/

script used :

Tmp:

Load

json2csv(@1, 'weather') as CSV_

From [xxx\city\city.list.json] (txt, utf8, no labels, delimiter is '');

Quotes:

LOAD * FROM_FIELD (Tmp, CSV_)

(txt, utf8, embedded labels, delimiter is ',', msq);

Drop Table Tmp;

Thanks in advance!

REFER: Qlikview and Json api

topic JSON question in QlikView

JSON question