Date: Thu, 22 Oct 2020 06:16:18 +0000 (GMT) Message-ID: <349998274.15155.1603347378794@df68ed866f50> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_15154_1925457789.1603347378794" ------=_Part_15154_1925457789.1603347378794 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html DEGREES Function

# DEGREES Function

Computes the degrees of an input value measuring the radian= s of an angle. The value can be a Decimal or Integer literal or a reference= to a column containing numeric values.
• Input units are in radians.

Wrangle vs. SQL: This function is part of Wrangle , a proprietary data transformation language.= Wrangle is not SQL. For more information, se= e Wrangle Language.

## Basic Usage

Numeric literal example:

=20

round(degrees(1.0000),4)

Ou= tput: Returns the computation in degrees of `1.0000` radians, which is `57.2728`, rounded to 4 decimals.

Column reference example:

=20

Ou= tput: Returns the conversion of the values in `MyRads` column to degrees.

## Synt= ax and Arguments

=20

degrees(numeric_value)

=20 =20 =20 =20 =20
Argument Required? Data Type Description
numeric_value Y string, decimal, or integer Name of column, Decimal or Integer literal, or f= unction returning those types to apply to the function

For more information on syntax standards, see Language Documentation Syntax Notes<= /a>.

### numeric_value

Name of the column, Integer or Decimal literal, or function returning th= at data type to apply to the function.

• Missing input values generate missing results.
• Literal numeric values should not be quoted. Quoted values are treated = as strings.
• Multiple columns and wildcards are not supported.

Usage Notes:

=20

=20 =20 =20 =20
Required? Data Type Example Value
Yes String (column reference) or Integer or Decimal = literal `3.14`

## Examples

### Example - DEG= REES and RADIANS functions

This example illustrates to use the DEGREES and RADIANS functions to con= vert values from one unit of measure to the other.

Source:

In this example, the source data contains information about a set of iso= sceles triangles. Each triangle is listed in a separate row, with the liste= d value as the size of the non-congruent angle in the triangle in degrees.<= /p>

You must calculate the measurement of all three angles of each isosceles= triangle in radians.

=20 =20 =20
triangle a01
t01 30
t02 60
t03 90
t04 120
t05 150

Transformation:

You can convert the value for the non-congruent angle to radians using t= he following:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula `Single row formula` `ROUND(RADIANS(a01), 4)` `'r01'`
=20

Now, calculate the value in degrees of the remaining two angles, which a= re congruent. Since the sum of all angles in a triangle is 180, the followi= ng formula can be applied to compute the size in degrees of each of these a= ngles:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula `Single row formula` `(180 - a01) / 2` `'a02'`
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula `Single row formula` `ROUND(RADIANS(a02), 4)` `'r02'`
=20

Create a second column for the other congruent angle:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula `Single row formula` `ROUND(RADIANS(a02), 4)` `'r03'`
=20

To check accuracy, you sum all three columns and convert to degrees:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula `Single row formula` `ROUND(RADIANS(a02), 4)` `'checksum'`
=20

Results:

After you delete the intermediate columns, you see the following results= and determine the error in the checksum is acceptable:

=20 =20 =20 =20 =20 =20 =20
triangle a01 r03 r02 r01 checksum
t01 30 1.3095 1.3095 0.5238 179.9967
t02 60 1.0476 1.0476 1.0476 179.9967
t03 90 0.7857 0.7857 1.5714 179.9967
t04 120 0.5238 0.5238 2.0952 179.9967
t05 150 0.2619 0.2619 2.6190 179.9967

=20