Page tree

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

Compare with Current View Page History

« Previous Version 12 Next »

Trifacta Dataprep


Contents:

On April 28, 2021, Google changed the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

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.