Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion board where members can learn more about Qlik Sense Data Connectivity.
I have Web Api that generates JSON with such structure:
{
"City1": {
"Category1": [
{
"Name": "Name1",
"MonththlyValue": [ 4,2,1,3,3,2,3,2,1,4,2,5],
"Target": 2
},
"Category2": [
{
"Name": "Name2",
"MonththlyValue": [ 4,2,1,3,3,2,3,2,1,4,2,5],
"Target": 3
},
...
},
"City2": {
"Category1": [
{
"Name": "Name1",
"MonththlyValue": [ 4,2,1,3,3,2,3,2,1,4,2,5],
"Target": 2
},
"Category2": [
{
"Name": "Name2",
"MonththlyValue": [ 4,2,1,3,3,2,3,2,1,4,2,5],
"Target": 3
},
...
},
...
}
JSON has information about each city, each category in this city and each value for that category spread among 12 months.
I've read on this forum that such nested JSON files are not feasable to work with. I have the ability to modify the way how this JSON is structured. So my question is how would you recommend to restructure this JSON so that it will be easy to make dashboards?
Should this be restructured in a such way that it only consists of flat objects with extra keys in them describing Cities and Categories? Should each object be splitted into 12 different ones for each month?