How to read Nested JSON file in QlikView.

deep — Sat, 16 Nov 2024 18:26:52 GMT

hi There,

can anyone help me how can I read a NESTED JSON file

for eg: my json file is something like this. (it's a small part of my JSON data)

{
"title": "",
"description": "",
"position": 10,
"question_count": 1,
"id": "1234",
"href": "https://something.something",
"questions": [
{
"id": "123",
"position": 1,
"visible": true,
"family": "single",
"subtype": "ver",
"sorting": null,
"required": {
"text": "",
"type": "all",
"amount": "50"
},
"validation": null,
"forced_ranking": false,
"headings": [
{
"heading": "In process"
}
],
"href": "https://something",
"answers": {
"choices": [
{
"position": 1,
"visible": true,
"text": "50%",
"quiz_options": {
"score": 0
},
"id": "316"
},
{
"position": 4,
"visible": true,
"text": "51% - 60%",
"quiz_options": {
"score": 0
},
"id": "107"
},
{
"position": 3,
"visible": true,
"text": "61% - 70%",
"quiz_options": {
"score": 0
},
"id": "108"
},
{
"position": 4,
"visible": true,
"text": "71% - 80%",
"quiz_options": {
"score": 0
},
"id": "109"
},
{
"position": 5,
"visible": true,
"text": "81% - 90%",
"quiz_options": {
"score": 0
},
"id": "110"
},
{
"position": 6,
"visible": true,
"text": "91% - 100%",
"quiz_options": {
"score": 0
},
"id": "111"
}
]
}
}
]
},

I want to load this JSON file and I need it in a single-table output.

please help me...

Thanks,

Deep

Re: How to read Nested JSON file in QlikView.

MakMakesitpossible — Wed, 24 Jun 2020 21:03:42 GMT

I believe there is a JSON connector available.

Re: How to read Nested JSON file in QlikView.

deep — Wed, 24 Jun 2020 21:11:06 GMT

hello @MakMakesitpossible ,

I am looking to read the JSON file or convert the JSON file into CSV or XML so, it will be very easy for me to load into QlikView.

Thanks

topic Re: How to read Nested JSON file in QlikView. in QlikView

How to read Nested JSON file in QlikView.

Re: How to read Nested JSON file in QlikView.

Re: How to read Nested JSON file in QlikView.