Replace data in source table from other table

[Nicolaas_Vercruyse]

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

[mceleavey · Accepted solution]

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.

[Luke_C · Accepted solution]

Hi @Nicolaas_Vercruyse 

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 · Accepted solution]

Hi,

You can use join tool.

Let me know if it woks.

Karolina

[Nicolaas_Vercruyse]

Thanks all, worked fine!!

Nicolaas