Convert JSON file to CSV

[#1]

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

[Gysbert_Wassenaar]

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

[#3]

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

[Gysbert_Wassenaar]

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.

[#5]

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

[#6]

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