...
You can use basic comparison operators to perform comparisons on your data. In this example, the compareCol column is generated as the evaluation of 3 < 6, which is true:
| d- |
|---|
...
| showNote | true |
|---|
...
| trans | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
|
For more information, see Comparison Operators.
...
Boolean values can be true or false, so comparisons like the following can be applied to a Boolean set of values:
| d- |
|---|
...
| trans | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
In the above case, the value in Attendance is set to true if the value in the isSeated column is true. Otherwise, the current value in Attendance is used.
...
| Info |
|---|
NOTE: Both parameters of the |
| d- |
|---|
...
| trans | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
|
See DATEDIF Function.
Compare String Values
...
