Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Creating date range from 2 separate date rows

joannasokolowska
8 - Asteroid

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. 

 

NameCoursedate startdate end
John, SmithABC2021-08-02 9:00:002021-08-03 14:00:00
Anna, Sting1232021-08-17 9:00:002021-08-18 14:00:00

 

 

Thanks,

Asia

2 REPLIES 2
jamielaird
14 - Magnetar

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.

 

jamielaird_0-1623318514667.png

 

joannasokolowska
8 - Asteroid

Thanks! it works 🙂 

Labels