Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Convert JSON file to CSV

Hi Team,

          Need help here,,,,

Want to import data from Json file but can't able to do so. please provide me solution.

Tried to convert from Json to  xml it suffers from performance issue.

sample json file :

{
    "glossary": {
        "title": "example glossary",
          "GlossDiv": {
            "title": "S",
               "GlossList": {
                "GlossEntry": {
                    "ID": "SGML",
                         "SortAs": "SGML",
                         "GlossTerm": "Standard Generalized Markup Language",
                         "Acronym": "SGML",
                         "Abbrev": "ISO 8879:1986",
                         "GlossDef": {
                        "para": "A meta-markup language, used to create markup languages such as DocBook.",
                              "GlossSeeAlso": ["GML", "XML"]
                    },
                         "GlossSee": "markup"
                }
            }
        }
    }
}

We are having 2 GB Json file.

Regads,

spider

5 Replies

Re: Convert JSON file to CSV

There are tons of freely available json to csv converters available on the internet. Try one.


talk is cheap, supply exceeds demand
Not applicable

Re: Convert JSON file to CSV

In our organization its not allowed to install third party tools...

Re: Convert JSON file to CSV

There are online converters too. Though perhaps not for 2GB files. Qlikview cannot read json so you will need to either get the source to output to another format or use some converting utility. Or write your own in any script language available to you. There's enough example code out there.


talk is cheap, supply exceeds demand
Not applicable

Re: Convert JSON file to CSV

I am new to qlikivew, please help me with sample application it will be helpfull.

Not applicable

Re: Convert JSON file to CSV

Talk to the guys at https://json-csv.com - I know they can convert files that large (perhaps for a fee though).

Community Browser