Hi folks,
I'm back again as I've hit another snag with finishing up this project. Essentially I have a table of people and the dates they are taking leave.
What I need to do is create a new column called Return Date that will hold the person Return Date based on the day he or she comes back from leave.
You will see that people have leave for a few days at a time so for example Johns Return Date would be be 28/04/2023. I have no clue if Alteryx can do this but any help is massively appreciated as this is my final hurdle to wrapping up my project. 😀
Here is a dummy sample similar to the real thing.
Name | ID | Leave_Date | Leave_Type | Approved | Year | |
John | 16450 | 18/04/2023 | Annual Leave | 1 | 2023 | John@dummy.ie |
John | 16450 | 19/04/2023 | Annual Leave | 1 | 2023 | John@dummy.ie |
John | 16450 | 20/04/2023 | Annual Leave | 1 | 2023 | John@dummy.ie |
John | 16450 | 21/04/2023 | Annual Leave | 1 | 2023 | John@dummy.ie |
John | 16450 | 24/04/2023 | Annual Leave | 1 | 2023 | John@dummy.ie |
John | 16450 | 25/04/2023 | Annual Leave | 1 | 2023 | John@dummy.ie |
John | 16450 | 26/04/2023 | Annual Leave | 1 | 2023 | John@dummy.ie |
John | 16450 | 27/04/2023 | Annual Leave | 1 | 2023 | John@dummy.ie |
John | 16450 | 28/04/2023 | Annual Leave | 1 | 2023 | John@dummy.ie |
Tim | 13010 | 02/05/2023 | Annual Leave | 1 | 2023 | Tim@dummy2.ie |
Tim | 13010 | 12/05/2023 | Annual Leave | 0.5 | 2023 | Tim@dummy2.ie |
Tim | 13010 | 19/05/2023 | Annual Leave | 0.5 | 2023 | Tim@dummy2.ie |
Tim | 13010 | 26/06/2023 | Annual Leave | 1 | 2023 | Tim@dummy2.ie |
Tim | 13010 | 27/06/2023 | Annual Leave | 1 | 2023 | Tim@dummy2.ie |
Liam | 13010 | 28/06/2023 | Annual Leave | 1 | 2023 | Liam@dummy3.ie |
Liam | 13010 | 29/06/2023 | Annual Leave | 1 | 2023 | Liam@dummy3.ie |
Liam | 13010 | 30/06/2023 | Annual Leave | 1 | 2023 | Liam@dummy3.ie |
Liam | 13010 | 03/07/2023 | Annual Leave | 1 | 2023 | Liam@dummy3.ie |
Liam | 13010 | 04/07/2023 | Annual Leave | 1 | 2023 | Liam@dummy3.ie |
Liam | 13010 | 05/07/2023 | Annual Leave | 1 | 2023 | Liam@dummy3.ie |
Hi @Deano478 Can you share what your expected output looks like? Would John's return data actually be 29/04/2023 as that's the day following the last leave day?
Could you do a summarize by employee and max leave date?
Hey @Luke_C my apologies I should have mentioned that yeah Johns return date would be the 29th in this case
Also @Luke_C apologies for the confusion The output will essentially just include another column called return date which as we said before would be the day following the last day of leave.