Hi , I have a Table test1 when values of variables Flow_typ,Region,Account_status and Amount are equal and diff between end date of first record and start date of next record is 1 then collapse all those records as 1 for that group (Flow_typ,Region,Account_status and Amount) when values of variables Flow_typ,Region,Account_status and Amount are equal and diff between end date of first record and start date of next record is > 1 then treat as different row Output should be like Test2 . Test1 Flow_typ Region Account_Status Amount St_date end_date Internal South Open 100 1/1/2020 1/31/2020 Internal South Open 200 2/1/2021 2/28/2021 Internal South Open 200 5/1/2030 5/31/2030 Internal South Open 200 6/1/2030 6/30/2030 Internal South Open 200 7/1/2030 7/31/2030 External North Closed 50 1/1/2024 1/31/2024 External North Closed 60 2/1/2024 2/28/2024 External North Closed 50 3/1/2026 3/31/2026 External North Closed 50 4/1/2026 4/30/2026 External North Closed 50 5/1/2026 5/31/2026 Can anyone please help me . Thanks in Advance Test 2 Flow_typ Region Account_Status Amount St_date end_date Internal South Open 100 1/1/2020 1/31/2020 Internal South Open 200 2/1/2021 2/28/2021 Internal South Open 200 5/1/2030 7/31/2030 External North Closed 50 1/1/2024 1/31/2024 External North Closed 50 3/1/2026 5/31/2026 External North Closed 60 2/1/2024 2/28/2024
... View more