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:
first_name
last_name
To apply the Expand JSON filter:
Select Expand JSON.
Select Add Filter.
The Expand JSON dialog opens.
Select Add to add details for Expanded Columns. This is necessary for the Expand JSON filter to be applied.
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 |