Forum Discussion

KayKay1965's avatar
KayKay1965
Copper Contributor
Mar 16, 2024

Grouping by date

This is my data set,  how to  grouping by next occurance of Null

 

Start_Date      End_Date

 

2020-01-15     NULL
2020-01-15     2020-01-15
2020-01-17     2020-01-17
2020-01-21     2020-01-17
2020-01-22     2020-01-21
2020-01-23     2020-01-22
2020-01-24     2020-01-23
2020-01-24     2020-01-24 ---> This End_Date will be End_Date for the Start_Date = 2020-01-15
2020-12-28      NULL
2020-12-28     2020-12-28
2020-12-28     2020-12-28
2020-12-28     2020-12-28
2020-12-28     2020-12-28
2020-12-28     2020-12-28
2020-12-28      2020-12-28
2021-01-12      2021-01-11---> This End_Date will be End_Date for the Start_Date =2020-12-28
2021-09-22      NULL
2021-09-22      2021-09-22
2021-09-29      2021-09-22
2021-09-29      2021-09-29
2021-11-12         2021-11-12 ---> This End_Date will be End_Date for the Start_Date =2021-09-22


Final Result result will be like this

2020-01-15       2020-01-24
2020-12-28       2021-01-11
2021-09-22       2021-11-12

 

 

No RepliesBe the first to reply

Share

Resources