Dear colleagues
I need your advise regarding creating date range for 2 separate rows.
I attached Alteryx workflows with example data sets.
This how I would like to see the output.
Name | Course | date start | date end |
John, Smith | ABC | 2021-08-02 9:00:00 | 2021-08-03 14:00:00 |
Anna, Sting | 123 | 2021-08-17 9:00:00 | 2021-08-18 14:00:00 |
Thanks,
Asia
Solved! Go to Solution.
Hi @joannasokolowska ,
Here's a solution. You can group by each name and select the min of the start and max of the end date. It really only requires one tool, but I've added a couple more to keep the sort order consistent.
Thanks! it works 🙂