Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

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.

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 12 rates

This page has no comments.