Hi All
I'm trying to compare multiple fields from 2 sources and match each field from source A to source B. Is there a way to find what was matched and not matched and flag the results?
Input:
Source A:
Internal Key | First Name | Last Name |
Party1 | Mary | Smith |
Party2 | John | Smith |
Party3 | Maddie | Mac |
Party4 | Max | Zackary |
Source B:
Internal Key | First Name | Last Name |
Party1 | Mary | Smith |
Party2 | John | Smith |
Party3 | Maddy | Mac |
Expected Results:
Source | Internal Key | First Name | Last Name | Source | Internal Key | First Name | Last Name | Match Internal Key | Match First Name | Match Last Name |
A | Party1 | Mary | Smith | B | Party1 | Mary | Smith | Y | Y | Y |
A | Party2 | John | Smith | B | Party2 | John | Smith | Y | Y | Y |
A | Party3 | Maddie | Mac | B | Party3 | Maddy | Mac | Y | N | Y |
B | Party4 | Max | Zackary | N | N | N |
I want to be able to flag that:
1. Party1 and Party2 are definite match for every field
2. Party3 has different First Name in Source B
3. Party 4 is in Source A but not in Source B
I've been joining both sources and putting a formula for each field where field from Source A = field from Source B, which works ok but one of the tables has 72 fields!
Hope above makes sense.
Thank you in advance.
Solved! Go to Solution.
Hi @mcmb, try the workflow attached and let me know if it works.
Make sure that in the multi field formula you select all the "match" columns and dynamic or unknown fields
Thanks again