Page tree


Contents:

Our documentation site is moving!

For up-to-date documentation of Designer Cloud on AWS, please visit us at https://help.alteryx.com/AWS/.

   


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.