I have one dataset:
SERIAL # | Column 2 | Column 3 | Column 4 |
6461321 | 0.19126 | 0.704599 | 0.928773 |
9794531 | 0.247302 | 0.936941 | 0.916397 |
63138 | 0.37155 | 0.993595 | 0.165754 |
656566 | 0.849803 | 0.010742 | 0.656271 |
646465 | 0.642514 | 0.731193 | 0.494899 |
898863 | 0.136802 | 0.686417 | 0.00769 |
6565868 | 0.282694 | 0.588152 | 0.169832 |
I have new info for certain records. So I need to replace those fields associated with that Serial #.
My second dataset looks like:
SERIAL # | Column 2 | Column 3 | Column 4 |
9794531 | 0.876896 | 0.776042 | 0.726424 |
63138 | 0.481164 | 0.908962 | 0.459649 |
898863 | 0.025477 | 0.811302 | 0.932458 |
So the resulting table......would keep the old info but replace all fields where needed
So result would look like:
SERIAL # | Column 2 | Column 3 | Column 4 |
6461321 | 0.19126 | 0.704599 | 0.928773 |
9794531 | 0.876896 | 0.776042 | 0.726424 |
63138 | 0.481164 | 0.908962 | 0.459649 |
656566 | 0.849803 | 0.010742 | 0.656271 |
646465 | 0.642514 | 0.731193 | 0.494899 |
898863 | 0.025477 | 0.811302 | 0.932458 |
6565868 | 0.282694 | 0.588152 | 0.169832 |
Where the 2nd, 3rd, and 6th row gets updated.
All solutions I have found depend on a formula where I would enter EACH Serial # I want replaced.
Surely there is a way to look at an entire table - and replace values when a criteria matches (in this case, serial #)
Dynamic Replace?
Thanks
Solved! Go to Solution.
Hi @CorCor
Solution is attached.
I'm sure there are many ways to approach the update of a table, but one way to do this is by using the Join tool. By joining on serial number, selecting only the New info (Columns which have been renamed to RIGHT_Column name) and then renaming the columns to union back to the main data - you can achieve your intended output.
Hope this helps!
Hi @CorCor
What about a Join Tool, and then a Union, producing a Left Join?
Whatever you match on the J anchor, you union to what you don't match at the L anchor (which it should be your primary set).
The secret is to select the Right side as your output columns of the J anchor, clearing the automatic renaming.
Cheers,
Thanks! It did the job!
Corey