Start Free Trial

Alteryx Designer Desktop Discussions

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

Split time period into different rows

hcao
6 - Meteoroid

Is there a way I can transform this roster data:

Start time End timeBreak duration
2018-01-02 07:00:002018-01-02 13:30:000.5

into this:

Start time End time
2018-01-02 07:00:002018-01-02 12:00:00
2018-01-02 12:00:002018-01-02 12:30:00
2018-01-02 12:30:002018-01-02 13:30:00

 

basically i have ~1,000,000 records and I want to split all the records at the 5-hour mark and add 30 mins (this is the break time)

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

@hcao - This should do the trick,

Screenshot 2024-06-12 154720.png

Raj
16 - Nebula

@hcao 
find the workflow attached
this is made dynamic
hope this helps you

for multiple rows of record convert this into macro and this will work

Labels
Top Solution Authors