Hi All, I need to compare 2 datasets containing info by unique RecId for two different periods. My requirements are - > Flag record as "Updated" if any of the variable is changed compared to previous period data. > Flag record as "New" if any new record is added in the current period data. Sample Datasets - PREV_PERIOD RecID Age Income Region 1001 23 1000 1 1002 54 2500 3 1003 41 8000 5 1004 47 4500 4 1005 21 5000 2 CUR_PERIOD RecID Age Income Region 1001 23 1000 1 1002 54 3500 3 1003 41 8000 5 1004 47 4500 3 1005 22 5000 2 1006 36 9000 1 1007 60 5000 4
... View more