Qliksense dataload with SQL table one JSON value column

[harshalshah]

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

[ajaykakkar93]

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/StringFunction...