Replace values if there's a match

[jamiep004]

Hi community, 

I have to datasets A and B. In both datasets, there is a column containing reference numbers. Where reference in A matches reference in B, I want to replace the values in the column containing 'amounts' in dataset B with the values in A. To illustrate:

A

Reference	Amount
10567	980.00
10568	710.00

B

Reference	Amount
10567	966.00
10568	700.00

desired output:

B

Reference	Amount
10567	980.00
10568	710.00

Basically, I need the amounts ONLY in B to change to A where a match of reference is found.Is this possible?

[AbhilashR · Accepted solution]

@jamiep004 - you could join the two dataset on Reference column to achieve this result. Sample solution attached.

Please mark this post as solution accepted if it answers your question.