Extract JSON Array to Sub-table
Extracts each value in a JSON array to a row in a sub-table.
Example
| id | name | data |
|---|---|---|
| 1 | John | [“burger”, “fries”] |
| 2 | Jane | [“steak”, “salad”] |
→
| id | name |
|---|---|
| 1 | John |
| 2 | Jane |
Sub-table with primary key id
id | value |
|---|---|
| 1 | burger |
| 1 | fries |
| 2 | steak |
| 2 | salad |
Configuration
Column
Select a column to parse as JSON arrays.
Operation
Extract Subtable should be selected for this transform.
Adding the Transform
- Select a column with JSON array data by clicking its column header in the table.
- Find Split JSON array transform under JSON group.
Alternatively, you can click on + Add Script Step on the right of the wrangler to find Split JSON array under JSON group.
Key Considerations
- This transform removes the original column from the main table.
- Setting a primary key enables you to join the sub-table to the main table.
- Each element of the array is extracted into its own row with the matching primary key value from the original record.
- You cannot currently add transformations to a sub-table. To perform transformations in Etleap with sub-table data, we’d recommend creating a separate pipeline with your warehouse as the source and sub-table as your resource.