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

[Motivator]

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.

AgencyNo	ClubMemberForeName	ClubMemberSurName
632893	Kay	Harrison
981100
1030162

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

AgencyNo	First Name	Last Name
1030162	Andrew	Whiting
5107693	R	Harries
5731872	Eleanor	Fish

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

[messi007 · Accepted solution]

@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

Attached the workflow,

Regards

[Motivator]

Great thanks so much for the quick response😀.