LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

How do I create a compare between two tables to create two new outputs (match & unmatched)

1) Find corresponding field 1 from table 1 in table 2
2) Take corresponding field 2 from table 1 and see if they exist in field 2 table 2. If all values exist from field 2, table 1 in field 2, table to it is a match. Please note multiple values exist comma separated.
3) Create two outputs using table 2, one for matched and one for unmatched.
In the example below there is one that should return as a match and one as unmateched


Table 1
Field 1 Field 2
ABC a,d,f -matched
DEF a,b,g - unmatched

Table 2
Field 1 Field 2
ABC a,b,d,f,h - matched
DEF a,g,q,z - unmatched (value 'b' is not found)

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

The attached BRE solved the problem
Attachments:
Solution.brg