| Previous Article | matchIT SQL Index | Next Article |
4.5.1.1 msp_GroupExactMatches
Input Parameters:
- Configuration file – the file path of the configuration file to be used when this procedure is run.
- Datasource ID – specifies the data source to be used from the configuration file, which contains the table and column mapping specifications of the first dataset.
After running msp_FindExactMatches, this will group all matching record pairs into sets of matching records, and will create tables that are referenced by a following instance of msp_FindMatches.
|
Setting |
Description |
|
dataSources |
Defines the database connection, tables, and columns of the datasets that are to be matched. |
|
outputSettings->exactMatchesTable |
Name of the table containing the exact matching pairs results which are to be grouped into matching sets. |
|
outputSettings->groupedExactMatchesTable |
Name of the output table to be created when the grouping runs. |
4.5.1.2 Exact_matches_grouped table structure
During processing the stored procedure will output the results to the exact_matches_grouped table (this name can be configured – see above). The structure of the output table is as follows:
|
Column |
Description |
|
ID |
Record ID for each matching group. |
|
Record1 |
Reference ID of the first record in the matching pair. |
|
Record2 |
Reference ID of the second record in the matching relationship. |
|
MatchRef |
ID of the matching group that the records belong to. Note that the MatchRef will be the ID value of the first record in the matching group. |
| Previous Article | matchIT SQL Index | Next Article |