Page tree

 

Support | BlogContact Us | 844.332.2821

 

Contents:

This documentation applies to Trifacta Wrangler. Download this free product.
Registered users of this product or Trifacta Wrangler Enterprise should login to Product Docs through the application.

Returns the value of multiplying the first argument by the second argument. Equivalent to the * operator.

  • Each 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 value: MULTIPLY(10,4) as:'forty'

Output: The values 10 and 4 are multiplied and stored in a new column called forty

Syntax

derive value:MULTIPLY(value1, value2)

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.
value2YstringThe second 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, value2

Integer or Decimal expressions, column references or literals to multiply together.

  • 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

Example - Numeric Functions

This example demonstrate the following numeric functions: 

Source:

ValueAValueB
82
104
1510
56

Transform:

Execute the following transforms:

derive value:ADD(ValueA, ValueB) as:'add'

derive value:SUBTRACT(ValueA, ValueB) as:'subtract'

derive value:MULTIPLY(ValueA, ValueB) as:'multiply'

derive value:DIVIDE(ValueA, ValueB) as:'divide'

derive value:MOD(ValueA, ValueB) as:'mod'

derive value:NEGATE(ValueA) as:'negativeA'

Results:

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

ValueAValueBnegativeAmoddividemultiplysubtractadd
82-80416610
104-1022.540614
1510-1551.5150525
56-550.83333333330-111

 

Your Rating: Results: PatheticBadOKGoodOutstanding! 81 rates

This page has no comments.