topic Re: JSON convertor in QLIVIEW in QlikView

JSON convertor in QLIVIEW

0li5a3a — Wed, 15 Mar 2017 14:49:10 GMT

Hi Guys,

I checked all the community discussions about JSON but I don't understand the logic. Could someone drive me on to the right direction?

I need to extract data from MySQL and I have a column what contain the data using JSON format.

I want to thank you in advance !

Re: JSON convertor in QLIVIEW

adamdavi3s — Wed, 15 Mar 2017 14:50:44 GMT

Did you find this?

JSON Loader

Parsing JSON in QlikView Desktop?

Re: JSON convertor in QLIVIEW

0li5a3a — Wed, 15 Mar 2017 14:59:02 GMT

I found this but I need to extract data from MySQL server i don't have an url

Re: JSON convertor in QLIVIEW

adamdavi3s — Wed, 15 Mar 2017 15:00:11 GMT

Ok, can you possibly provide a sample of how the table looks with a row of data?

It'll be possible somehow

Re: JSON convertor in QLIVIEW

adamdavi3s — Wed, 15 Mar 2017 15:01:19 GMT

Just found this from hoangvvo‌

You can do a select on the json string to create a data model.

ex:jsonstring= [{"key1":"value1"},{"key2":"value2"}]

Tmp:

Load Id,Name,Address;

SQL Select Id,

Name=JSON_VALUE(JSonStringColumn,'$.key1'),

Address=JSON_VALUE(JsonStringColumn,'$.key2')

from your table

Re: JSON convertor in QLIVIEW

0li5a3a — Wed, 15 Mar 2017 15:36:44 GMT

if I want to use Qlik general web connector do you know how to configure it?