Skip to main content

FindChangedRecords

FindChangedRecords Function​

Finds the records from the left table that match on the specified key columns but differ on any other columns, to a corresponding record in the right table. This method will find the records in the left table with the same values in the columns specified but with different values in all other columns from the right table.

Syntax​

FindChangedRecords(table LeftTable, table RightTable, scalar Column1, scalar Column2,...)

Arguments​

ArgumentDescription
table LeftTableLeft Table
table RightTableRight Table
scalar Column1, Column2, ...A list (scalar) of column names to use to check for matches.

Examples:

FindChangedRecords([[FusionTestTable]], [[FusionTestTable2]], "DecimalColumn","DoubleColumn")

Returns records in FusionTestTable that match on key columns "DecimalColumn" and "DoubleColumn" but differ on any other column, to a corresponding record in FusionTestTable2.