Skip to main content

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​

NameDescriptionAccepted ValuesDefaultRequired
I/O
inputName of the column to be split.string, integer—Yes
outputName of column(s) for the results. If providing a single column, use a wildcard (*) to indicate a incrementing integer.string, array—Yes
Conditions
ifCondition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}.string—No
whereFilter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'.string—No
where_paramsValues 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']
Column1Column2Column3
ABC
wrangles:
- split.list:
input: Column
output:
- Heading A
- Heading B
- Heading C
Column
['A', 'B', 'C']
Heading AHeading BHeading C
ABC
Access
RequirementValue
AI-poweredNo
Requires WrangleWorks accountNo
Requires subscriptionNo
Requires external API keyNo
Technical details
FieldValue
Catalog ID64
Catalog keysplit.list
Recipe keysplit.list
Catalog statusactive
Lifecycle statusactive
Recipe Writer eligibleYes
Namespacesplit
Documentation groupsplit
AliasesNone
Runtime symbolwrangles.recipe_wrangles.split.list
Legacy UUID3260b9f7-aae2-499f-8004-d211c2cf643e

Sources