Page tree

Trifacta Dataprep


If you licensed Dataprep by Trifacta before Oct. 14, 2020, you are using the Dataprep by Trifacta Legacy product edition. On October 14, 2022, this product edition will be decommissioned by Google and will be no longer available for use. Current customers of this product edition are encouraged to transition to one of the product editions hosted by Trifacta. See Product Editions.


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.