Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Update master data sets by matching on 1 field to update 2 other fields

Motivator
7 - Meteor

Hi, this may be simple but for the life of me I can't figure it out.

 

I have a Master data set which contains approx. 16K records.

 

AgencyNoClubMemberForeNameClubMemberSurName
632893KayHarrison
981100  
1030162  

 

I then have a Second smaller data set that has some of the records, with the extra missing data.

 

AgencyNoFirst NameLast Name
1030162AndrewWhiting
5107693RHarries
5731872EleanorFish

 

 

So I want to update the Master dataset, with the missing data where the "AgencyNo" matches?

 

Can anyone point me in the right direction?

Thanks

 

2 REPLIES 2
messi007
15 - Aurora
15 - Aurora

@Motivator,

 

Below how you can do it :

 

1- Join with Agence NO

2- Formula to update the first and last name when they match

3- Union to have all records in the master file

 

messi007_0-1631722546051.png

 

Attached the workflow,

Regards

Motivator
7 - Meteor

Great thanks so much for the quick response😀.

Labels
Top Solution Authors