Explode / String Layer
Convert string characters into separate rows. Similar to Polars explode(), pandas explode(), or SQL UNNEST. Creates a new row for each string character, duplicating all other column values.
Example transformation:
Input:
| id | values |
|---|---|
| 1 | Hi |
| 2 | Ok |
Output:
| id | value |
|---|---|
| 1 | H |
| 1 | i |
| 1 | O |
| 2 | K |
Table
0
0
Table
Select
columnThe string column to explode:
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.