Hello All, I have a dataset containing dates with gaps, and my objective is to detect these gaps between the dates and subcategorize them based on the continuity of each gap. Thanks. This is what i have: Cat1 Cat2 AdmDt A 1 01/01/2022 A 1 01/02/2022 A 1 01/03/2022 A 1 01/10/2022 A 1 01/11/2022 A 1 01/12/2022 A 2 01/01/2022 A 2 01/02/2022 This is what i want: Cat1 Cat2 AdmDt Subcategory_id A 1 01/01/2022 1 A 1 01/02/2022 1 A 1 01/03/2022 1 A 1 01/10/2022 2 A 1 01/11/2022 2 A 1 01/12/2022 2 A 2 01/01/2022 3 A 2 01/02/2022 3
... View more