NEQ (!=)
Basic Overview
|
Description |
It compares the rows of two inputs and will return true (1) if the values are not equal and false (0) otherwise. |
|
Syntax |
|
|
Parameter |
|
Example
Input A =
|
Year |
Value |
|---|---|
|
2019 |
400 |
|
2020 |
700 |
|
2021 |
850 |
|
2022 |
500 |
Input B =
|
Year |
Value |
|---|---|
|
2019 |
350 |
|
2020 |
400 |
|
2021 |
850 |
|
2022 |
600 |
Output NEQ('A','B') =
|
Year |
Value |
|---|---|
|
2019 |
1 |
|
2020 |
1 |
|
2021 |
0 |
|
2022 |
1 |