Language Documentation Syntax Notes

Contents:

Expand all Collapse all

NOTE: Designer Cloud Educational is a free product with limitations on its features. Some features in the documentation do not apply to this product edition. See Product Limitations.

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.

See Also for Language Documentation Syntax Notes:

Send Feedback

Page tree

Language Documentation Syntax Notes