Matching on different attributes

Owned by Peter Tse
Aug 16, 2018

When you are doing equality matching on the same attribute, this condition is usually sufficient:

Record1.Forename = Record2.Forename

But when you want to do a match on different attributes, for example:

Record1.Forename = Record2.Nickname

then this is no longer sufficient, as it is possible to miss one direction.

The match condition needs to be:

Record1.Forename = Record2.Nickname
OR
Record2.Forename = Record1.Nickname


Step-by-step guide