Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

The cloud-based product Trifacta Free is available now! Register for your free account.

 

Returns the opposite of the value that is the first argument. Equivalent to the - operator placed in front of the argument.
  • The argument can be a literal Integer or Decimal number, a function returning a number, or a reference to a column containing numeric values.

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Numeric Operators.

 

Basic Usage

derive type:single value: NEGATE(MyValue) as:'oppositeOfMyValue'

Output: The opposite of the value in the MyValue column is stored in a new column oppositeOfMyValue

Syntax and Arguments

derive type:single value:NEGATE(value1)

ArgumentRequired?Data TypeDescription
value1YstringThe first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types.

For more information on syntax standards, see Language Documentation Syntax Notes.

value1

Integer or Decimal expressions, column references or literals.

  • Missing or mismatched values generate missing string results. 

Usage Notes:

Required?Data TypeExample Value
YesLiteral, function, or column reference returning an Integer or Decimal value15

Examples

Tip: For additional examples, see Common Tasks.

Example - Numeric Functions

This example demonstrate the following numeric functions:

Source:

ValueAValueB
82
104
1510
56

Transformation:

Execute the following transformation steps:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula ADD(ValueA, ValueB)
Parameter: New column name 'add'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula SUBTRACT(ValueA, ValueB)
Parameter: New column name 'subtract'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula MULTIPLY(ValueA, ValueB)
Parameter: New column name 'multiply'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula DIVIDE(ValueA, ValueB)
Parameter: New column name 'divide'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula MOD(ValueA, ValueB)
Parameter: New column name 'mod'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula NEGATE(ValueA)
Parameter: New column name 'negativeA'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula LCM(ValueA, ValueB)
Parameter: New column name 'lcm'

Results:

With a bit of cleanup, your dataset results might look like the following:

ValueAValueBlcmnegativeAmoddividemultiplysubtractadd
828-80416610
10420-1022.540614
151030-1551.5150525
5630-550.83333333330-111

 

  • No labels

This page has no comments.