FindNewRecords
Find NewRecords Functions
Finds the records from the left table that do not have a corresponding match in the right table on the specified key columns. This method will find the records in the left table where there is no corresponding values in the columns specified in the right table.
Syntax
FindNewRecords(table LeftTable, table RightTable, scalar Column1, scalar Column2,...)
Arguments
| Argument | Description |
|---|---|
table LeftTable | Left Table |
table RightTable | Right Table |
scalar Column1, Column2, ... | A list (scalar) of column names to use to check for matches, or NULL to specify all columns |
Examples:
FindNewRecords([[FusionTestTable]], [[FusionTestTable2]], "VarCharColumn", "BigIntColumn")
Returns records in FusionTestTable that do not match a record in FusionTestTable2 on the keys "VarCharColumn" and "BigIntColumn".