Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Compare and Match multiple fields from multiple data source

mcmb
6 - Meteoroid

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 KeyFirst NameLast Name
Party1MarySmith
Party2JohnSmith
Party3MaddieMac
Party4MaxZackary

 

Source B:

Internal KeyFirst NameLast Name
Party1MarySmith
Party2JohnSmith
Party3MaddyMac

 

Expected Results:

SourceInternal KeyFirst NameLast NameSourceInternal KeyFirst NameLast NameMatch Internal KeyMatch First NameMatch Last Name
AParty1MarySmithBParty1MarySmithYYY
AParty2JohnSmithBParty2JohnSmithYYY
AParty3MaddieMacBParty3MaddyMacYNY
    BParty4MaxZackaryNNN

 

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.

4 REPLIES 4
mborriero
11 - Bolide

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

Capture.JPG

 

 

 

 

mcmb
6 - Meteoroid

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

mborriero
11 - Bolide

Of course, I forgot!

mcmb
6 - Meteoroid

Thanks again

Labels