If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hello,
I 'm trying to load into the script a JSON file that is really large. It has more than 10 million lenght so..
I couldn't find a doable way to set it correctly
If anyone knows how to do it, please, I appreciate it.
Thanks in advance,
Fukumoto.
Hi, I've recenntly found out a way to parse a JSON string into a table. Check the sample code:
Table: load '[ { "date": "2019-04-04", "agency": "aaa", "revenue": 55 }, { "date": "2019-04-04", "agency": "bbb", "revenue": 45 }, { "date": "2019-04-03", "agency": "aaa", "revenue": 52 }, { "date": "2019-04-03", "agency": "bbb", "revenue": 42 } ]' as JSON AutoGenerate (1); load * FROM_FIELD (Table, JSON) (json, utf8, no labels); drop table Table;
Hope this helps.