SOLVED
Update master data sets by matching on 1 field to update 2 other fields
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Motivator
7 - Meteor
‎09-15-2021
09:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Datasets
- Join
- Output
- Preparation
2 REPLIES 2
messi007
15 - Aurora
‎09-15-2021
09:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎09-15-2021
10:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great thanks so much for the quick response😀.