Qliksense dataload with SQL table one JSON value column

harshalshah — Wed, 19 Mar 2025 23:02:17 GMT

Hello Team,

I would like to know way , i can load the data in Qliksense via data load statement

JSON value :{"data":{"html_attribute_values":{"category":"3793927b-3070-11ee-9af4-0242ac190006","available_for":"379bf4ab-3070-11ee-9af4-0242ac190006","manufacturer":"37946764-3070-11ee-9af4-0242ac190006","model":"37967133-3070-11ee-9af4-0242ac190006","engine_type":"379a2cde-3070-11ee-9af4-0242ac190006","country_location":"3791be47-3070-11ee-9af4-0242ac190006"},"esn":"11111","available":"2023-08-01","owner":"Test","leave_comments":"......"}}

Kindly let me know procedure or step for the same to load data in proper table format

Thanks
Harshal

Re: Qliksense dataload with SQL table one JSON value column

ajaykakkar93 — Wed, 30 Aug 2023 03:32:22 GMT

Hi,

You can use the below in your load statement
JsonGet(og,'/data/html_attribute_values/category') as [_category]

Link to help

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/JsonGet.htm

topic Re: Qliksense dataload with SQL table one JSON value column in Data Movement & Streaming

Qliksense dataload with SQL table one JSON value column

Re: Qliksense dataload with SQL table one JSON value column