mSQL - msp_GroupExactOverlap

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.

 

 

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.