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.
Thanks a lot. Annoyingly I was so close! Missed the column name in the Loop Expression. Really appreciate that.
@SamThomas ahh no way! I've done that more times than I'd like to admit 😂.