Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
13 - Pulsar

@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