Equal to: =
Syntax
left = right
Input parameters
left |
the left operand |
right |
the right operand |
Examples of valid syntaxes
DS_1 = DS_2
Semantics for scalar operations
The operator returns TRUE if the left is equal to right, FALSE otherwise.
For example:
| 5 = 9
gives: FALSE
| 5 = 5
gives: TRUE
| “hello” = “hi”
gives: FALSE
Input parameters type
left, right
dataset {measure<scalar>}
| component<scalar>
| scalar
Result type
result
dataset { measure<boolean> bool_var }
| component<boolean>
| boolean
Additional Constraints
Operands left and right must be of the same scalar type
Behaviour
The operator has the typical behaviour of the “Operators changing the data type” (see the section “Typical behaviours of the ML Operators”).
Examples
Given the operand datasets DS_1:
Example 1
DS_r := DS_1 = 0.08;
results in (see structure):
Id_1 |
Id_2 |
Id_3 |
Id_4 |
bool_var |
---|---|---|---|---|
2012 |
B |
Total |
Total |
|
2012 |
G |
Total |
Total |
False |
2012 |
S |
Total |
Total |
False |
2012 |
M |
Total |
Total |
False |
2012 |
F |
Total |
Total |
True |
2012 |
W |
Total |
Total |
True |
Example 2
DS_r := DS_1 [ calc Me_2 := Me_1 = 0.08 ];
results in (see structure):
Id_1 |
Id_2 |
Id_3 |
Id_4 |
Me_1 |
Me_2 |
---|---|---|---|---|---|
2012 |
B |
Total |
Total |
||
2012 |
G |
Total |
Total |
0.286 |
False |
2012 |
S |
Total |
Total |
0.064 |
False |
2012 |
M |
Total |
Total |
0.043 |
False |
2012 |
F |
Total |
Total |
0.08 |
True |
2012 |
W |
Total |
Total |
0.08 |
True |