Page tree


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:

This page has no comments.