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