On April 28, 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 simple example demonstrate available comparison functions:
-
LESSTHAN- See LESSTHAN Function.
-
LESSTHANEQUAL- See LESSTHANEQUAL Function.
-
EQUAL- See EQUAL Function. -
NOTEQUAL- See NOTEQUAL Function. GREATERTHAN- See GREATERTHAN Function.-
GREATERTHANEQUAL- See GREATERTHANEQUAL Function.
Source:
| colA | colB |
|---|---|
| 1 | 11 |
| 2 | 10 |
| 3 | 9 |
| 4 | 8 |
| 5 | 7 |
| 6 | 6 |
| 7 | 5 |
| 8 | 4 |
| 9 | 3 |
| 10 | 2 |
| 11 | 1 |
Transformation:
Add the following transforms to your recipe, one for each comparison function:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | LESSTHAN(colA, colB) |
| Parameter: New column name | 'lt' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | LESSTHANEQUAL(colA, colB) |
| Parameter: New column name | 'lte' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | EQUAL(colA, colB) |
| Parameter: New column name | 'eq' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | NOTEQUAL(colA, colB) |
| Parameter: New column name | 'neq' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | GREATERTHAN(colA, colB) |
| Parameter: New column name | 'gt' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | GREATERTHANEQUAL(colA, colB) |
| Parameter: New column name | 'gte' |
Results:
| colA | colB | gte | gt | neq | eq | lte | lt |
|---|---|---|---|---|---|---|---|
| 1 | 11 | false | false | true | false | true | true |
| 2 | 10 | false | false | true | false | true | true |
| 3 | 9 | false | false | true | false | true | true |
| 4 | 8 | false | false | true | false | true | true |
| 5 | 7 | false | false | true | false | true | true |
| 6 | 6 | true | false | false | true | true | false |
| 7 | 5 | true | true | true | false | false | false |
| 8 | 4 | true | true | true | false | false | false |
| 9 | 3 | true | true | true | false | false | false |
| 10 | 2 | true | true | true | false | false | false |
| 11 | 1 | true | true | true | false | false | false |
This page has no comments.