Operations Guide

10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.1 HotFix 1
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

Master Rules

This section provides information on the options in the Master Rules.

modal exact

Selects the records with the greatest number of columns that contain the modal (most common) value. The modal value is determined by a strict comparison.

sdf snippet


merge-definition
*===============
NAME= person-merge-modal
MASTER-SELECTION= modal-exact
*
merge-master-definition
*======================
NAME= modal-exact
TYPE= modal-exact
*

Input	Result
Name Addr updated John Smith 12 Maine Street 14072008 John Smith 12 Main Street 13072008 Jon Smith 12 Main Street 23082008	John Smith 12 Main Street 13072008

Cluster Merge Rules

most filled

modal exact

Selects the records with the greatest number of columns filled.

sdf snippet


merge-definition
*===============
NAME= person-merge-most-filled
MASTER-SELECTION= most-filled
*
merge-master-definition
*======================
NAME= most-filled
TYPE= most-filled
*

Input	Result
Name Addr updated John Smith 14072008 John Smith 12 Main Street 13072008 Jon Smith 12 Main Street	John Smith 12 Main Street 13072008

most data

Selects the records with the most data (longest sum of string lengths). Column with a NULL value will not add to the total length

sdf snippet


merge-definition
*===============
NAME= person-merge-most-data
MASTER-SELECTION= most-data
*
merge-master-definition
*======================
NAME= most-data
TYPE= most-data
*

Input	Result
Name Addr updated John Smith 12 Main Street 14072008 John Smith 12 Maine Street 13072008 John Smythe 12 Maine Street	John Smith 12 Maine Street 13072008

column max

Selects the records with the greatest value in a particular column. The COLUMN field must be provided.

sdf snippet


merge-definition
*===============
NAME= person-merge-newest
MASTER-SELECTION= newest
*
merge-master-definition
*======================
NAME= newest
TYPE= column-max
COLUMN= updated
*
merge-column-definition
*======================
NAME= updated
FORMAT= "DMY"
*

Input	Result
Name Addr updated John Smith 12 Main St 14072009 John Smith 12 Maine Street 13072009 Jon Smith 12 Main Street 14082009 John Smyth 12 Maine Street 13082009	Jon Smith 12 Main Street 14082009

column min

Selects the records with the lowest value in a particular column. The COLUMN field must be provided.

sdf snippet


merge-definition
*===============
NAME= person-merge-oldest
MASTER-SELECTION= oldest
*
merge-master-definition
*======================
NAME= oldest
TYPE= column-min
COLUMN= updated
*
merge-column-definition
*======================
NAME= updated
FORMAT= "DMY"
*

Input	Result
Name Addr updated John Smith 12 Main St 14072009 John Smith 12 Maine Street 13072009 Jon Smith 12 Main Street 14082009 John Smyth 12 Maine Street 13082009	John Smith 12 Maine Street 13072009

column equals

Selects the records where a particular column equals a given value. The COLUMN and VALUE fields must be provided.

sdf snippet


merge-definition
*===============
NAME= person-merge-verified
MASTER-SELECTION= column-verified-equals
*
merge-master-definition
*======================
NAME= column-verified-equals
TYPE= column-equals
COLUMN= verified
VALUE= Y
*

Input	Result
name street verified updated John Smith 12 Main St N 14072009 John Smith 12 Maine Street N 13072009 John Smyth 12 Maine Street Y 13082009	John Smyth 12 Maine Street Y 1308200909

Rename Saved Search

Table of Contents

Operations Guide

Operations Guide

Master Rules

Master Rules

most filled

most data

column max

column min

column equals