List
Split a list in a single column to multiple columns.
Split a list into multiple columns. If only one output is given, split.list returns the same list it was given, so output should be a list of columns or a column name with a wildcard (*).
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|---|---|---|---|
| I/O | ||||
input | Name of the column to be split. | string, integer | — | Yes |
output | Name of column(s) for the results. If providing a single column, use a wildcard (*) to indicate a incrementing integer. | string, array | — | Yes |
| Conditions | ||||
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
Examples
wrangles:
- split.list:
input: Column
output: Column*
| Column |
|---|
| ['A', 'B', 'C'] |
| Column1 | Column2 | Column3 |
|---|---|---|
| A | B | C |
wrangles:
- split.list:
input: Column
output:
- Heading A
- Heading B
- Heading C
| Column |
|---|
| ['A', 'B', 'C'] |
| Heading A | Heading B | Heading C |
|---|---|---|
| A | B | C |
Access
| Requirement | Value |
|---|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|---|
| Catalog ID | 64 |
| Catalog key | split.list |
| Recipe key | split.list |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | split |
| Documentation group | split |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.split.list |
| Legacy UUID | 3260b9f7-aae2-499f-8004-d211c2cf643e |
Sources