SOLVED
Replace data in source table from other table
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
Nicolaas_Vercruyse
7 - Meteor
‎05-06-2021
05:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear all,
I'm looking for a solution to replace some data from my source table with data from another table.
Source table
Vendor | Qt | Ctry |
1 | 10 | SE |
2 | 20 | DE |
3 | 10 | BE |
4 | 30 | NL |
5 | 15 | IT |
other table
Vendor | Ctry |
3 | SK |
5 | GB |
So result would be like this
Vendor | Qt | Ctry |
1 | 10 | SE |
2 | 20 | DE |
3 | 10 | SK |
4 | 30 | NL |
5 | 15 | GB |
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
4 REPLIES 4
17 - Castor
‎05-06-2021
06:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Nicolaas_Vercruyse ,
this is a simple join and replace function.
I joined the tables together on the key field (Vendor) and replaced where they join with the input from the second table, then unioned them together.
Hope this helps.
M.
17 - Castor
‎05-06-2021
06:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's two approaches, 1 with find and replace, and one with the Join tool. Both are fairly straightforward but let me know if you have any questions.
KarolinaRoza
11 - Bolide
‎05-06-2021
06:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-06-2021
11:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks all, worked fine!!
Nicolaas
