topic Re: Convert JSON file to CSV in QlikView

Convert JSON file to CSV

Wed, 28 Jan 2015 14:32:00 GMT

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

Re: Convert JSON file to CSV

Gysbert_Wassenaar — Wed, 28 Jan 2015 14:48:17 GMT

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

Re: Convert JSON file to CSV

Wed, 28 Jan 2015 15:11:56 GMT

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

Re: Convert JSON file to CSV

Gysbert_Wassenaar — Wed, 28 Jan 2015 15:20:17 GMT

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.

Re: Convert JSON file to CSV

Wed, 28 Jan 2015 15:30:24 GMT

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

Re: Convert JSON file to CSV

Sun, 29 Mar 2015 17:50:34 GMT

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