Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

In this documentation, working examples are complete

D s lang
 commands. Example:

d-

...

trans
RawWrangletrue
p03Value'five'
Typestep
WrangleTextderive type:single value:(2 + 3) as:'five'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(2 + 3)
p03NameNew column name
SearchTermNew formula

All syntax commands use the following generalized structure:

d-

...

trans
RawWrangletrue
p03Value(expression)
Typestep
WrangleTexttransform-name [param1:param_value1] param2:FUNCTION_NAME(arg1,[arg2]) [param3:(expression)] param4:param_value4|param5:param_value5
p01Nameparam1
p01Valueparam_value1
p02Nameparam2
p02ValueFUNCTION_NAME(arg1,[arg2])
p03Nameparam3
p04Value'param_value4'
p04Nameparam4
SearchTerm[Search Term in Transform Builder]

  • Inputs:
    • For transformstransformations, 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.