Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I get the following error when I use the From_Field function:
This is my code:
Any help is appreciated!