Generate Time slot rows

[Rossella]

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!!

[DavidP]

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.

[rupali_bhise · Accepted solution]

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.

[seinchyiwoo · Accepted solution]

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.

Attaching the workflow for you as reference.

Cheers,

Seinchyi

[Rossella · Accepted solution]

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

That is very helpful!