Previous Article | matchIT SQL Index | Next Article |
4.5.2.1 msp_GroupExactOverlap
Input Parameters:
- Configuration file – the file path of the configuration file to be used when this procedure is run.
- Main 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.
- Overlap datasource ID – specifies the data source to be used from the configuration file, which contains the table and column mapping specifications of the second dataset to be used in the overlap.
After running msp_FindExactOverlap, 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_FindOverlap.
Setting |
Description |
dataSources |
Defines the database connection, tables, and columns of the datasets that are to be used in the overlap. |
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. Note that if the overlap attribute is blank, then the name will be taken from the Name attribute. |
4.5.2.2 Overlap 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 taken from the first datasource. |
Record2 |
Reference ID of the record from the second datasource that is deemed to match Record1 From the first datasource. |
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 and will be from the second datasource. |
Previous Article | matchIT SQL Index | Next Article |