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.
