Replace data in source table from other table

Question

Dear all,

I'm looking for a solution to replace some data from my source table with data from another table.

Source table

VendorQtCtry1

10

SE

220DE310BE430NL515IT

other table

VendorCtry3SK5GB

So result would be like this

VendorQtCtry110SE220DE310SK430NL515GB

mceleavey · Accepted Answer

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 Answer

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 Answer

Hi,

You can use join tool.

Let me know if it woks.

Karolina