The Expand JSON filter can transform JSON objects in your data set into multiple separate new columns.

As an example, if you had a column with a JSON object like: {“first_name”: “John”, “last_name”: “Doe”}, the Expand JSON Filter could extract those values from your JSON and create the following columns:

To apply the Expand JSON filter:

  1. Select Expand JSON.

  2. Select Add Filter.

    The Expand JSON dialog opens.



  3. Select Add to add details for Expanded Columns. This is necessary for the Expand JSON filter to be applied.


  4. Edit the parameters and select Next.

Parameter

Description

JSON column name (required)

Name of the column to be extracted

JSON Path root

JSON Path where the extraction begins

Default timezone

Default timezone of timestamp columns if not included in the value

Expanded JSON column

If checked, the original column will be kept after expansion

Invalid record

If checked, the import will be stopped if an invalid record is encountered

Cache provider

Cache provider name for JSON Path

Expanded Columns

Column name

Name of column defined by JSON Path

Data type

Data type of the column value