# Expanding JSON Filter

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:

1. Select **Expand JSON**.
2. Select **Add Filter**.


The **Expand JSON** dialog opens.

![](/assets/image2020-12-16_16-51-53.d3c19d0135662b461ee294e07fac0192ead03b462de4501dcc6a7571a6cc285e.ef656343.png)

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


![](/assets/image2020-12-16_16-52-38.c0dc5c95ee7b629b06a6c6999d4e12312ce276d35b837d955bf4a7c68d23c842.ef656343.png)

1. 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 |