Skip to main content

Suffix

Add a suffix to a column.

Add a suffix to a column

Parameters​

NameDescriptionAccepted ValuesDefaultRequired
I/O
inputName of the input column.string, integer, array—Yes
output(Optional) Name of the output column.string, nullnullNo
Options
valueSuffix value to add.string, integer, number, array—Yes
skip_emptyWhether to skip empty values.booleanfalseNo
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:
- format.suffix:
input: Data
output: Suffix
value: ic
Data
sto
hero
icon
Suffix
stoic
heroic
iconic
Access
RequirementValue
AI-poweredNo
Requires WrangleWorks accountNo
Requires subscriptionNo
Requires external API keyNo
Technical details
FieldValue
Catalog ID37
Catalog keyformat.suffix
Recipe keyformat.suffix
Catalog statusactive
Lifecycle statusactive
Recipe Writer eligibleYes
Namespaceformat
Documentation groupformat
AliasesNone
Runtime symbolwrangles.recipe_wrangles.format.suffix
Legacy UUID8d127060-ba2d-4934-897f-07662e01e40b

Sources