Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Creating date range from 2 separate date rows

joannasokolowska
9 - Comet

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
9 - Comet

Thanks! it works 🙂 

Labels
Top Solution Authors