Problem: Need help to club events running on same weeks into a single row.
Data input is at Event-Start Date (Sunday) – End Date (Saturday).
For events having same start date and overlapping period, need to club into a single row
Please see input in the screenshot –
-
E1, E2, E3 all starts at same date but end dates are not exactly same. E3 is running for an additional week. Therefore, Clubbed E1, E2, E3 into same event for the overlapping period. For the additional period E3 was running, a separate row is created for that particular week.
-
E4 is also overlapping for week falling in mid, this need not be clubbed since its start date is different.
Please help. I have tried using windows functions
I have tried windows functions