Creating date range from 2 separate date rows

[joannasokolowska]

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

[jamielaird · Accepted 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.

[joannasokolowska]

Thanks! it works 🙂