Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Highlighted
lightsection
New Contributor III

How to convert nested JSON output into a single table

How do we convert nested JSON data into a clean straight table format. 

Using REST Connector, the nested data look like this:

nested json.png

 

Data Model: Multiple tables get created for each hierarchy instead of 1 single fact table. 

nested json 2.pngHow do we convert these into a single table in a dynamic fashion.

4 Replies
dilipranjith
Honored Contributor

Re: How to convert nested JSON output into a single table

What do you mean by "convert in a dynamic fashion"?
Principle to convert this into a start schema is same as converting a transnational DB tables to a star schema
lightsection
New Contributor III

Re: How to convert nested JSON output into a single table

This is just 1 JSON file, containing data for 1 element of the whole data model.
I have similar JSON files that will add more tables to the whole data model.

The idea is be able to view each file in a single table format , instead of multiple sub tables
dilipranjith
Honored Contributor

Re: How to convert nested JSON output into a single table

Not an expert by any mean on JSON
but IMHO JSON nesting basically means its different json objects or "tables"/"datastructures" (for the lack of a better term) underneath the hood. Which is why you are getting multiple tables.

like i mentioned before to covert to a flat structure you need to de-normalize.

Hope i understood correctly
fernandobibian
New Contributor III

Re: How to convert nested JSON output into a single table

Hi Lightsection,

I understand your struggle. We also faced this problem working with JIRA API and we added this feature as an out-the-box feature of our connector.

I hope it helps you!

Here is a video to see it in action:

Community Browser