Finding Return Dates

[Deano478]

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	Email
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

[Luke_C]

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?

[braveraj]

Could you do a summarize by employee and max leave date?

 

[Deano478]

Hey @Luke_C  my apologies I should have mentioned that yeah Johns return date would be the 29th in this case

[Deano478]

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.

[braveraj]