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?
Solved! Go to 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.