Generate Time slot rows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!!
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you all for the solutions. Now I understand what I was doing wrong.
That is very helpful!