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.