Generate a list of dates
- 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 am looking to generate a column of data named 'Date' (or anything) with the starting date being today()-1826 days and for each new row to incrementally +1 day until it reaches today's date. So I then have a column of data with 1826 dates, from 5 years ago to todays date.
I just need to be able to create this out of 'thin air' essentially. I don't have another column to use. I need Alteryx to generate it.
I have tried and tried using the generate rows tool, but can't seem to crack it. Any help would be gratefully received.
Thanks.
Solved! Go to Solution.
- Labels:
- Developer Tools
- 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
Thanks a lot. Annoyingly I was so close! Missed the column name in the Loop Expression. Really appreciate that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@SamThomas ahh no way! I've done that more times than I'd like to admit 😂.
