Hi, I want to track changes of a person's status and find their minimum start and maximum end dates for each change. The raw datatable below is a sample where you can see for person A the minimum start and maximum end date for their Main status are 01Jan15 to 01Feb16. So for Row 1 and 2 there's no change in status and since EndDt for row 1 is 06July15 and StartDt for row 2 is 07July15 there's no break in the period, and the two rows should be aggregated into one row start on 01Jan15 and end on 01Feb16. The 3rd row should be kept because there's a break in the period even though status stays in Main, StartDt is 01Oct16 and EndDt is 31Dec16. The 4th and 5th row should be aggregated into one row that reads status in Co and StartDt is 01Jan17 and EndDt is 01Sep17. The 6th row should be kept unchanged start from 30Oct17 to 05Nov17. The desired reduced datatable is copied below the raw datatable Raw datatable Row ID Status StartDt EndDt 1 A Main 01-Jan-15 06-Jul-15 2 A Main 07-Jul-15 01-Feb-16 3 A Main 01-Oct-16 31-Dec-16 4 A Co 01-Jan-17 07-Jul-17 5 A Co 08-Jul-17 01-Sep-17 6 A Co 30-Oct-17 05-Nov-17 Desired reduced datatable ID Status MinStartDt MaxEndDt A Main 01-Jan-15 01-Feb-16 A Main 01-Oct-16 31-Dec-16 A Co 01-Jan-17 01-Sep-17 A Co 30-Oct-17 05-Nov-17 This problem has been bugging me for days, I appreciate any suggestions I could get. Also I am new to this, so could you please give more details in your answers? Many Thanks! Michelle
... View more