Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Generate Time slot rows

Rossella
5 - Atom

Hi,

 

I need to generate a table on Alteryx as it follows till the time slot 23:45:00

 

SLOT
00:00:00
00:15:00
00:30:00
00:45:00
01:00:00
01:15:00
01:30:00

I searched on this community and I managed to set up a generate tool which seems to be working but it is like that keeps generating the rows over and over again. How do I make it stop generating rows after the value 23:45:00?

 

Please find the workflow attached.

 

Thanks!!

 

 

4 REPLIES 4
DavidP
17 - Castor
17 - Castor

I amended your workflow slightly, keeping the year and changing datatype to datetime in Generate rows, then use multi-field formula to change both value and datatype of SLOT to time.

 

DavidP_0-1591283740117.png

 

rupali_bhise
8 - Asteroid

Hey @Rossella 

Attaching workflow for your reference, you only need to add date+time into expression and then remove date part into it,

Good luck.

 

GenerateRowSeconds.png

seinchyiwoo
Alteryx Alumni (Retired)

I think that's because you are only looking at the time but not the date (that you want it to be just looking at the same day).

I looked at the date in the generation tool, then convert it to time using Select tool and it works.

seinchyiwoo_0-1591285232615.png

 

Attaching the workflow for you as reference.

 

Cheers,

Seinchyi

Rossella
5 - Atom

Thank you all for the solutions. Now I understand what I was doing wrong.

That is very helpful!

Labels
Top Solution Authors