topic Re: Convert table to JSON object file in QlikView

Convert table to JSON object file

Tue, 29 Jul 2014 08:02:18 GMT

Dear Experts,

I have a scenario where I wish to convert my table in qlikview to JSON file.

Can anybody help me out with this issue?

Thanks in advance.

Regards,

Pramod K

Re: Convert table to JSON object file

nigel987 — Tue, 24 May 2016 13:38:56 GMT

Hi Pramod,

could you solve this issue? I have a similar problem.

KR,
Nigel

Re: Convert table to JSON object file

Thu, 26 May 2016 07:37:35 GMT

No Nihal. I was not able to.

Re: Convert table to JSON object file

Anil_Babu_Samineni — Thu, 26 May 2016 08:02:47 GMT

Try to post, Good Example with Clarification Output.

You have table and then your table data transfer to Qlikview and then QlikView to JSON ---?

Try this ..

JSON Loader

Re: Convert table to JSON object file

jonathandienst — Thu, 26 May 2016 08:34:30 GMT

You could write a macro to perform the conversion, but it's could be a little complex.

There are commercial CSV to JSON converters, as well as several online ones. Google 'Convert CSV to JSON' for more. It may be possible to automate the commercial tools, otherwise you will have to export the CSV and then use an on-line converter manually to get the JSON.

Re: Convert table to JSON object file

nigel987 — Fri, 27 May 2016 10:17:50 GMT

Hi there,

I used a simple text object where I concatenated the data into a JSON string. This solution might not be always applicable, but was good enough for me.