Does Qlik can process JSON files directly ? Please suggest

[vish123]

Does Qlik can process JSON files directly ? Please suggest

Thanks

vish

[Ranganath_DR]

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

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

[NadiaB]

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

    <fields>

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

(json, codepage is 1252, embedded labels)

Hope it helps!!

[vish123]

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.