Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with columns: StartDate, EndDate, Items
Items is a field with json data like:
[{"Item":"Apple","Qty":"1"},{"Item":"Pear","Qty":"2"},{"Item":"Orange","Qty":"3"}]
(the number of Item-Qty pairs in each record is different)
I wonder if there's a way to have qlik sense parse this json field?
Thanks in advance!
this can be done. I think it can be even done with the Qlik Rest connector. otherwise you need to create a parser yourself. (i've added some links to solved postes)
if the data is from an API then Qlik can process it for you (you can use the REST connecter from Qlik).
Using Rest connector to parse JSON data.
https://community.qlik.com/t5/New-to-Qlik-Sense/PARSE-JSON-DATA/td-p/1876417
here are some sources that can help you with parsing the data yourself.
https://community.qlik.com/t5/New-to-Qlik-Sense/Qlik-Sense-parsing-of-a-json-field/td-p/1795740