ExplodeList / GroupBy Layer
Transform a list column into multiple rows, similar to pandas explode() or SQL UNNEST. Each element in the list creates a new row while preserving all other column values.
Example transformations:
Before explosion:
| ID | tags | score |
|---|---|---|
| 1 | [red, blue] | 100 |
| 2 | [green] | 200 |
After explosion:
| ID | tags | score |
|---|---|---|
| 1 | red | 100 |
| 1 | blue | 100 |
| 2 | green | 200 |
Common applications:
- Normalizing tagged data
- Processing multi-value attributes
- Analyzing array-type columns
- Converting nested data to flat format
- Processing JSON array fields
- Handling multi-select responses
Table
0
0
Table
Select
columnList-type column to explode into multiple rows. Common scenarios:
- product_categories: [Electronics, Accessories]
- user_roles: [Admin, Editor, Viewer]
- sensor_readings: [12.5, 12.6, 12.4]
- email_recipients: [user1@mail.com, user2@mail.com] Other columns are duplicated for each list element.