Skip to main content

Language Documentation Syntax Notes

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.