Page Comparison

Scenario

Sometimes the data that you are trying to match is not exactly the same, but you still want to be able to align and merge data, or create a report on likely matches.

Create

two tables for data. The goal is to match up those records from

table 1 where at least 3 of 5 fields match

table 2.

Solution:

• Create a

• table for each input.
• Create a

• calculate

• table for the join.
• Make the pipe from one of the

• table a pull pipe and the pipe from the other is a lookup pipe.
• In the join

• table, for each record on the pull pipe, cycle thru all the records from the lookup pipe and flag those records where there is a match.