Forum Discussion
Helper IPower query date consolidation
sauravguha , shared solution in PM. Created start date and end dates based on the continuous streak
Community SupportHi , sauravguha
Not very clear .It is recommended to open another thread to explain your additional problem in more detail.
Best Regards,
Community Support Team _ Eason
Helper IHi, thanks for your assistance and sorry for not being able to clarify as needed. Below is a new example where i believe i would be able to explain more.
In the first 2 names, Prasanna, since he has two sets of leave dates which are not in continuation, expected result is same as Given data. However, on the name "Said", his first 2 leaves are in continuation, hence, expected result is a date range combining the same and making one and his 3rd date range is kept in a separate row since it is not in continuation with the first two date ranges.
Was i able to make it clearer? Thank you again for assisting.
| Given Data | Expected result | |||||||||
| Emp ID | Name | Start Date | End Date | Leave Type | Emp ID | Name | Start Date | End Date | Leave Type | |
| E1545 | Prasanna | 23-Mar-20 | 30-Mar-20 | AL | E1545 | Prasanna | 23-Mar-20 | 30-Mar-20 | AL | |
| E1545 | Prasanna | 01-Apr-20 | 30-Apr-20 | AL | E1545 | Prasanna | 01-Apr-20 | 30-Apr-20 | AL | |
| E116460 | Said | 10-Mar-20 | 16-Mar-20 | SL | E116460 | Said | 10-Mar-20 | 19-Mar-20 | SL | |
| E116460 | Said | 17-Mar-20 | 19-Mar-20 | SL | E116460 | Said | 28-Apr-20 | 30-Apr-20 | SL | |
| E116460 | Said | 28-Apr-20 | 30-Apr-20 | SL | E115838 | Suraj | 31-Mar-20 | 06-Apr-20 | AL | |
| E115838 | Suraj | 31-Mar-20 | 06-Apr-20 | AL | E115838 | Suraj | 11-Apr-20 | 15-Apr-20 | AL | |
| E115838 | Suraj | 11-Apr-20 | 15-Apr-20 | AL | E18433 | Manikandan | 22-Mar-20 | 15-Apr-20 | AL | |
| E18433 | Manikandan | 22-Mar-20 | 28-Mar-20 | AL | E116043 | George | 22-Mar-20 | 23-Apr-20 | SL | |
| E18433 | Manikandan | 29-Mar-20 | 15-Apr-20 | AL | E115882 | Permeshwar | 26-Mar-20 | 30-Mar-20 | AL | |
| E116043 | George | 22-Mar-20 | 06-Apr-20 | SL | E115882 | Permeshwar | 01-Apr-20 | 30-Apr-20 | AL | |
| E116043 | George | 07-Apr-20 | 15-Apr-20 | SL | E115587 | Illeperumage | 18-Mar-20 | 19-Mar-20 | AL | |
| E116043 | George | 16-Apr-20 | 23-Apr-20 | SL | E115587 | Illeperumage | 23-Mar-20 | 26-Mar-20 | AL | |
| E115882 | Permeshwar | 26-Mar-20 | 30-Mar-20 | AL | E115587 | Illeperumage | 17-Apr-20 | 30-Apr-20 | AL | |
| E115882 | Permeshwar | 01-Apr-20 | 30-Apr-20 | AL | E117332 | Hosny | 01-Mar-20 | 11-Mar-20 | SL | |
| E115587 | Illeperumage | 18-Mar-20 | 19-Mar-20 | AL | E117332 | Hosny | 26-Mar-20 | 30-Apr-20 | AL | |
| E115587 | Illeperumage | 23-Mar-20 | 26-Mar-20 | AL | ||||||
| E115587 | Illeperumage | 17-Apr-20 | 30-Apr-20 | AL | ||||||
| E117332 | Hosny | 01-Mar-20 | 01-Mar-20 | SL | ||||||
| E117332 | Hosny | 02-Mar-20 | 02-Mar-20 | SL | ||||||
| E117332 | Hosny | 03-Mar-20 | 03-Mar-20 | SL | ||||||
| E117332 | Hosny | 04-Mar-20 | 04-Mar-20 | SL | ||||||
| E117332 | Hosny | 05-Mar-20 | 05-Mar-20 | SL | ||||||
| E117332 | Hosny | 06-Mar-20 | 06-Mar-20 | SL | ||||||
| E117332 | Hosny | 07-Mar-20 | 07-Mar-20 | SL | ||||||
| E117332 | Hosny | 08-Mar-20 | 08-Mar-20 | SL | ||||||
| E117332 | Hosny | 09-Mar-20 | 09-Mar-20 | SL | ||||||
| E117332 | Hosny | 10-Mar-20 | 10-Mar-20 | SL | ||||||
| E117332 | Hosny | 11-Mar-20 | 11-Mar-20 | SL | ||||||
| E117332 | Hosny | 26-Mar-20 | 16-Apr-20 | AL | ||||||
| E117332 | Hosny | 17-Apr-20 | 24-Apr-20 | AL | ||||||
| E117332 | Hosny | 25-Apr-20 | 30-Apr-20 | AL |
- amitchandak
Super User
sauravguha , shared solution in PM. Created start date and end dates based on the continuous streak