Skip to main content
Version: 9.2

Hierarchical Data

Hierarchical data allows you to organize information in a nested structure to represent parent-child relationships. Qrvey can work with hierarchical data to create detailed, multi-level data visualizations and analyses.

Note: Hierarchical datasets are only available in Qrvey Ultra.

Create a Hierarchical Dataset​

Hierarchical data is often uploaded as a JSON file.

  1. Navigate to the Data > Dataset.

  2. Select New Dataset. A modal opens.

    hierarchical-data

  3. From your connections list, locate a JSON file.

  4. Select Create to open a modal.

View Hierarchical Dataset​

  1. Navigate to a hierarchical dataset.
  2. Select to open it.
    If your JSON file contains numeric or text arrays, objects, or object arrays, the UI will reflect this.

For example, assuming the following JSON structure:

[
    {
        "Name":"John Smith",
        "DOB":"12/23/1975",
        "children":2,
        "childrenAges":[10,12],                         // numeric array
        "carModels":["Ford","Chevy"],                   // string array
        "address": { "city":"Chicago", "state":"IL",},  // object
        "countriesVisited":[                            // object array
        { "id":10, "country":"Germany" }, 
        { "id":15, "country":"Spain" },
        { "id":18, "country":"Iraq" }
        ]
    }
]

The Data > Dataset > Columns page registers these new data structures.

  • There are new column types like Numeric Array, Text Array, Object, and Object Array.
  • The address column is an object that contains its own nested columns.
  • countriesVisited is an object array that contains its own nested columns. The column and its children are not selected and are disabled.

hierarchical-data

You can also navigate into the Data > Dataset > View Source Data tab to see how the raw data is registered in Qrvey.

Hierarchical data

The parent records in the main data source have a one-to-many relationship with countriesVisited object array, which can act like a left join between two relational tables and can be “inflated” to produce a flat dataset.

Customize Hierarchical Datasets​

You can apply Transformations and design and modify your dataset before loading it as well as flatten object arrays.

To flatten an object array, follow these steps.

  1. Select Transformations in the top right corner of the columns list.
  2. Drag the Array Flatten transformation to the workspace.
  3. Select the Inflate option from the dropdown.
Hierarchical data columns

When the Transformation dialog closes, the transformation flattens the array. You can view the result on the Dataset Design tab.

View source data