In this documentation, working examples are complete Wrangle commands. Example:
| Transformation Name | New formula |
|---|---|
| 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 | [Search Term in Transform Builder] |
|---|---|
| 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.