Replace Values in Columns in a Table using a different Table

[dmc141]

I have two tables, Table 1 and Table 2 as listed below. Note that Table 1 and Table 2 have matching column names, but Table 1 has extra columns which are not in Table 2. Also, both Table 1 and Table 2 have matching values in all the "Key" columns.

Using the matching keys in both Table 1 and Table 2, I want to replace the values which match using the values in Table 2. As a result, the new updated Table 1 should look like this:

I tried to do something like find and replace, but it seems like a very inefficient way to do it, so if anyone could help me with this I would greatly appreciate it. I also added the test data below, thank you!

[ntakeda · Accepted solution]

A common solution is to refer to columns from Table2 only when performing a JOIN.

I’ve created a workflow for your reference.

 

Let me know if this doesn’t meet your requirements.

[flying008 · Accepted solution]

Hi, @dmc141 

Another way for you: