EXAMPLE - POW and SQRT Functions

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

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:

z² = x² + y ²

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

z = sqrt(x² + y ² )

Source:

The dataset below contains values for x and y:

Transformation:

You can use the following transformation to generate values for z².

Single row formula

(POW(x,2) + POW(y,2))

'Z'

You can see how column Z is generated as the sum of squares of the other two columns, which yields z².

Now, edit the transformation to wrap the value computation in a SQRT function. This step is done to compute the value for z, which is the distance between the two points based on the Pythagorean theorem.

Single row formula

SQRT((POW(x,2) + POW(y,2)))

'Z'

Results: