Hello,
I have a requirement based on the following data;
for each unit, I need to set the Next_date field as the next consecutive start_date less one day. For example, the next date for line 1 should be 19-Jan-2020, line 2 should be 14-Feb-2020. And since there are no further lines for unit 1 on line 3, the next date should be today. Is there a way to do this in Alteryx?
thanks,
Line | Unit | Customer | Start_date | End_date | Next_date | What next date should be |
1 | 1 | A | 01-Jan-20 | 15-Jan 20 | 19-Jan-20 | |
2 | 1 | B | 20-Jan-20 | 31-Jan-20 | 14-Feb-20 | |
3 | 1 | C | 15-Feb-20 | 31-Mar-20 | 27-Apr-20 | |
4 | 2 | D | 01-Jan-20 | 28-Feb-20 | 14-Mar-20 | |
5 | 2 | E | 15-Mar-20 | 20-Mar-20 | 20-Mar-20 | |
6 | 2 | F | 21-Mar-20 | 31-Mar-20 | 27-Apr-20 |
Solved! Go to Solution.
Thank you Joseph,
this worked perfectly for my requirements.
Regards