Generate Time slot rows

Question

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

Time slots.yxmd

rupali_bhise · Accepted Answer

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 Answer

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 Answer

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

That is very helpful!