Load specific json data to qlik

Winter255 — Sat, 16 Nov 2024 19:18:58 GMT

Hello Gents,

Having issues trying to implement the following solution for json file load:

https://community.qlik.com/t5/QlikView-App-Development/Qlikview-and-Json-api/m-p/798923#M282134

I have json file structure such as:

{
"SoldItems": [
{
"ItemId": 1137722,
"exRate": 0.1788,
"exRate2": 0.5541,
"snp": 0.014
},
{
"ItemId": 1137723,
"exRate": 0.1388,
"exRate2": 0.5341,
"snp": 0.013
},
{
"ItemId": 1137724,
"exRate": 0.1668,
"exRate2": 0.5555,
"snp": 0.015
}

............
]
}

Could you please suggest the right solution to get the following outcome:

table with 4 columns ItemId, exRate, exRate2, snp

Re: Load specific json data to qlik

Winter255 — Wed, 15 Jan 2020 10:51:48 GMT

Best solution for such json structure located here:

https://community.qlik.com/t5/QlikView-Documents/Extracting-data-from-non-nested-Json-arrays/ta-p/1488191

topic Re: Load specific json data to qlik in QlikView

Load specific json data to qlik

Re: Load specific json data to qlik