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