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.