Page tree

 

Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

The following example demonstrates how the POW and SQRT functions work together to compute the hypotenuse of a right triangle using the Pythagorean theorem.

  • POW - X Y . In this case, 10 to the power of the previous one. See POW Function
  • SQRT - computes the square root of the input value. See SQRT Function.

The Pythagorean theorem states that in a right triangle the length of each side (x,y) and of the hypotenuse (z) can be represented as the following:

z2 = x 2 + y 2  

Therefore, the length of z can be expressed as the following:

z = sqrt(x 2  + y 2 )


For more information on the Pythagorean theorem, see https://en.wikipedia.org/wiki/Pythagorean_theorem.

Source:

The dataset below contains values for x and y:

 

XY
34
49
810
3040

Transform:

You can use the following transform to generate values for z2

NOTE: Do not add this step to your recipe right now.

derive type:single value:(POW(x,2) + POW(y,2)) as:'Z'

You can see how column Z is generated as the sum of squares of the other two columns. Now, wrap the value computation in a SQRT function:

derive type:single value:SQRT((POW(x,2) + POW(y,2))) as: 'Z'

Results:

XYZ
345
499.848857801796104
81012.806248474865697
304050

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 5 rates

This page has no comments.