Find and Replace on certain records

[CorCor]

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

[lmorrell · Accepted 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! 

[Thableaus]

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,

[Thableaus]

@CorCor 

Workflow attached.

[CorCor]

Thanks!  It did the job!

Corey