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!
Solved! Go to 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.
