The IdentityMatch function requires a source input table and a reference input table. The following two tables describe the input table columns that appear in the function syntax. The tables can have additional columns, but the function ignores them.
IdentityMatch Source Input Table Schema
Column Name |
Data Type |
Description |
a.id_column
|
Any |
Contains row identifiers. |
a.columnX
|
VARCHAR |
Contains strings. |
a.accumulate_column
|
Any |
Column to be copied to the output table. |
IdentityMatch Reference Input Table Schema
Column Name |
Data Type |
Description |
b.id_column
|
Any |
Contains row identifiers. |
b.columnY
|
VARCHAR |
Contains strings. |
b.accumulate_column
|
Any |
Column to be copied to the output table. |