community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Multiple Start/End Times within a Day

Meteoroid

Hi Community- I am stuck!  I need to create new columns (First Start Time/Last End Time) that only have the highlighted fields in columns C&D populate into columns E&F.  The issue is that sometimes there are multiple times per person within a given day, but I only need the first start time and last end time per day. Is there a way? I’m leaning towards sorting. 

 

I attached the file of the example data.

Magnetar
Magnetar

Do you actually want to create the duplicate rows for situations where there is more than one start/end time? 

 

If not, you should try the summarize tool - group by name & date, and then select minimum start time and maximum end time, which should give you one line for each person/day combination with the earliest start time and latest end time. 

 

If you want your data to keep the original number of rows, you could then join the above data back to the original data by name & date, and then you'd have both the original start & end times as well as the earliest start and latest end time for each row of original data...

 

Hope that helps! 

 

Cheers,

NJ

Highlighted
Meteoroid

Nicole, I just hit my easy Staples button for you.  Thank you!

Labels