Table #1
Yellow | Null |
Green | Null |
Blue | Null |
Black | Null |
Grey | Null |
Table #2
Black | 1.99 |
Grey | 1.79 |
I want to join these tables so that Black & Grey in table one are replaced by values in Table 2. I was able to do it via the join multiple tool but for some reason it changed the order of the values. I need the order to stay the same.
Yellow | Null |
Green | Null |
Blue | Null |
Black | 1.99 |
Grey | 1.79 |
Solved! Go to Solution.
hi @VanG ,
you can use the find and replace function to append the matched values.i hope this helps!