On January 27, 2021, Google is changing 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 illustrates how to apply basic trigonometric functions to your transformations. All of the functions take inputs in radians.
- Sine. See SIN Function.
- Cosine. See COS Function.
- Tangent. See TAN Function.
- Cotangent. Computed as 1/TAN.
- Secant. Computed as 1/COS.
- Cosecant. Computed as 1/SIN.
Source:
In the following sample, input values are in degrees:
| X |
|---|
| -30 |
| 0 |
| 30 |
| 45 |
| 60 |
| 90 |
| 120 |
| 135 |
| 180 |
Transformation:
In this example, all values are rounded to three decimals for clarity.
First, the above values in degrees must be converted to radians.
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | round(radians(X), 3) |
| Parameter: New column name | 'rX' |
Sine:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | round(sin(rX), 3) |
| Parameter: New column name | 'SINrX' |
Cosine:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | round(cos(rX), 3) |
| Parameter: New column name | 'COSrX' |
Tangent:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | round(tan(rX), 3) |
| Parameter: New column name | 'TANrX' |
Cotangent:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | round(1 / tan(rX), 3) |
| Parameter: New column name | 'COTrX' |
Secant:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | round(1 / cos(rX), 3) |
| Parameter: New column name | 'SECrX' |
Cosecant:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | round(1 / sin(rX), 3) |
| Parameter: New column name | 'CSCrX' |
Results:
| X | rX | COTrX | SECrX | CSCrX | TANrX | COSrX | SINrX |
|---|---|---|---|---|---|---|---|
| -30 | -0.524 | -1.73 | 1.155 | -1.999 | -0.578 | 0.866 | -0.5 |
| 0 | 0 | null | 1 | null | 0 | 1 | 0 |
| 30 | 0.524 | 1.73 | 1.155 | 1.999 | 0.578 | 0.866 | 0.5 |
| 45 | 0.785 | 1.001 | 1.414 | 1.415 | 0.999 | 0.707 | 0.707 |
| 60 | 1.047 | 0.578 | 1.999 | 1.155 | 1.731 | 0.5 | 0.866 |
| 90 | 1.571 | 0 | -4909.826 | 1 | -4909.826 | 0 | 1 |
| 120 | 2.094 | -0.577 | -2.001 | 1.154 | -1.734 | -0.5 | 0.866 |
| 135 | 2.356 | -1 | -1.414 | 1.414 | -1 | -0.707 | 0.707 |
| 180 | 3.142 | 2454.913 | -1 | -2454.913 | 0 | -1 | 0 |
This page has no comments.