Find and Replace on certain records

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

Tips and Tricks

Dynamic Processing

Preparation

Accepted answers

lmorrell

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.