topic Does Qlik can process JSON files directly ? Please suggest in App Development

Does Qlik can process JSON files directly ? Please suggest

vish123 — Wed, 07 Sep 2022 13:19:01 GMT

Does Qlik can process JSON files directly ? Please suggest

Thanks

vish

Re: Does Qlik can process JSON files directly ? Please suggest

Ranganath_DR — Wed, 07 Sep 2022 13:34:02 GMT

Hello @vish123 ,

Below thread might help you to get started with, kindly review.

https://community.qlik.com/t5/QlikView-App-Dev/how-to-load-JSON-file-data-in-to-qlikview/td-p/1657692

https://community.qlik.com/t5/New-to-Qlik-Sense/Qlik-Sense-parsing-of-a-json-field/td-p/1795740

Re: Does Qlik can process JSON files directly ? Please suggest

NadiaB — Wed, 07 Sep 2022 20:33:20 GMT

Hi @vish123

Could you provide more details about what are you trying to accomplish?

In addition to the previous information provided you can load .json files with something like this (very basic sample)

LOAD

FROM [lib://<data connection>/FileName.json]

(json, codepage is 1252, embedded labels)

Hope it helps!!

Re: Does Qlik can process JSON files directly ? Please suggest

vish123 — Thu, 08 Sep 2022 10:55:19 GMT

Hi NadiaB,

Thanks for your inputs.

I need to load a file with extension .json from my local machine into Qlik Sense. So just wondering if above example works for as the file contains nested data..Normally i would convert this json file to csv then load the data to Qlik.