Equal function
Boolean function that compares two columns to see if values match, row by row. Returns true
or false
.
Note: The columns must have the same data type.
Namespace
arithmetic
Input
Numeric values
Output
Boolean
Syntax
set-column :column arithmetic:equal(column1, column2)
Example
Compares values in items_US
with values in items_UK
and outputs true
if the values match or false
they don't match to the items_verified
column:
set-column :items-verified arithmetic:equal(items_US, items_UK)
Â
Created in 2020 by Google Inc.