In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Generate a list of dates

SamThomas
6 - Meteoroid

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. 

3 REPLIES 3
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

@SamThomas You can use the Generate Rows tool for this:

BS_THE_ANALYST_0-1676303283859.png

 

 

All the best,
BS

LinkedIN

Bulien
SamThomas
6 - Meteoroid

Thanks a lot. Annoyingly I was so close! Missed the column name in the Loop Expression. Really appreciate that. 

BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

@SamThomas ahh no way! I've done that more times than I'd like to admit ðŸ˜‚.

 

All the best,
BS

LinkedIN

Bulien
Labels
Top Solution Authors