Convert table to JSON object file - Qlik Community

Report Inappropriate Content · ‎2014-07-29

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

nigel987 · ‎2016-05-24

Hi Pramod,

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

KR,
Nigel

Report Inappropriate Content · ‎2016-05-26

No Nihal. I was not able to.

Anil_Babu_Samineni · ‎2016-05-26

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

jonathandienst · ‎2016-05-26

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

nigel987 · ‎2016-05-27

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.