Skip to main content

List Element

Select a numbered element of a list (zero indexed).

Parameters​

NameDescriptionAccepted ValuesDefaultRequired
I/O
inputName of the input column.string, integer, array—Yes
outputName of the output column.string, array, nullnullNo
Options
elementThe numbered element of the list to select. Starts from zero. This may use python slicing syntax to select a subset of the list.integer0No
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
Errors
defaultSet the default value to return if the specified element doesn't exist.string, number, array, object, boolean, null""No

Examples​

wrangles:
- select.list_element:
input: Col1
output: Second Element
element: 2 # Zero indexed
default: F
Col1
['A', 'B', 'C']
['D', 'E']
Third Element
C
F
Access
RequirementValue
AI-poweredNo
Requires WrangleWorks accountNo
Requires subscriptionNo
Requires external API keyNo
Technical details
FieldValue
Catalog ID57
Catalog keyselect.list_element
Recipe keyselect.list_element
Catalog statusactive
Lifecycle statusactive
Recipe Writer eligibleYes
Namespaceselect
Documentation groupselect
AliasesNone
Runtime symbolwrangles.recipe_wrangles.select.list_element
Legacy UUIDec40495d-d29a-4f62-86dd-eafa43cf388a

Sources