Hello All,
I have two datasets I will like to merge, they both have the same columns. I want to check to see if the counter column for a row has changed, if it hasn't, do nothing, if it has, create a new row
Dataset A
ID
RunDate
Count
S001
06OCT2021
6
S002
06OCT2021
2
Dataset B
ID
RunDate
Count
S001
07OCT2021
6
S002
07OCT2021
5
S003
07OCT2021
1
MERGED - The resultant dataset compares datasets A and B and will only to Dataset A where a record from B where the ID is same, but the Count is different and will also add a new row if an ID that isn't in A is now in B.
ID
RunDate
Count
S001
06OCT2021
6
S002
06OCT2021
2
S002
07OCT2021
5
S003
07OCT2021
1
I hope my explanation makes sense.
Thanks in advance.
... View more