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.

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 logic solved the problem
Attachments:
Solution.brg