Compare and Match multiple fields from multiple data source

[mcmb]

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.

[mborriero]

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

[mcmb]

Thank you @mborriero.  I'll give it a go.  Would you mind attaching the workflow please?

[mborriero · Accepted solution]

Of course, I forgot!

[mcmb]

Thanks again