Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Not applicable

Convert table to JSON object file

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

Tags (1)
5 Replies
Highlighted
Contributor II

Re: Convert table to JSON object file

Hi Pramod,

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

KR,
Nigel

Highlighted
Not applicable

Re: Convert table to JSON object file

No Nihal. I was not able to.

Highlighted

Re: Convert table to JSON object file

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
MVP
MVP

Re: Convert table to JSON object file

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
Highlighted
Contributor II

Re: Convert table to JSON object file

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.