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
Solved! Go to Solution.
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
Great thanks so much for the quick response😀.
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |