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 |