Free practice · ordering · medium

Practice

Order a classification check

Arrange a reliable workflow for classifying records into sets.

Category relationship map

Membership, overlap, and exclusion change the count

Membership

MemberInside
ExcludedOutside

Relationship

SubsetFully contained
OverlapShared members

Reconcile

UniqueA + B − overlap

Define each set before placing stable record identities, then reconcile overlap members exactly once in the unique total.

Arrange in the correct order
  1. 1. Reconcile unique members with the source total
  2. 2. Mark records that satisfy more than one rule
  3. 3. Test every record against every relevant rule
  4. 4. Use one stable identity for each record
  5. 5. Write the rule for each category