Language Documentation Syntax Notes
In this documentation, working examples are complete Wrangle commands. Example:
Transformation Name | |
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | (2 + 3) |
Parameter: New column name | 'five' |
All syntax commands use the following generalized structure:
Transformation Name | |
---|---|
Parameter: param1 | param_value1 |
Parameter: param2 | FUNCTION_NAME(arg1,[arg2]) |
Parameter: param3 | (expression) |
Parameter: param4 | 'param_value4' |
Inputs:
For transformations, inputs are called parameters.
For functions, inputs are called arguments.
Function names are written in ALL CAPS.
Square brackets [like this] indicate optional parameters or arguments.
Parentheses are used:
To bracket function inputs
To bracket expressions, such as
myCol >= 4
. In some of these instances, parentheses may be optional.
A vertical pipe (
|
) may be used between parameters or arguments that are paired. Typically, one of them may be used, but not both.