Alteryx Designer Desktop Discussions

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

Generate dynamic 12 months rows

DaisyJones
8 - Asteroid

Hi all, 

 

I want generate additional rows to my list of dates for the next 12 months, and I want this to be dynamic in the sense that if my list updates, it will only look 12 months ahead. Below is an image of roughly what I want.

 

Screenshot 2022-01-10 105331.png

   

Screenshot 2022-01-10 105421.pngI feel like this could be done with a generate rows tool, but I can't seem to figure it out. Any help would be appreciated!!

 

Thank you

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @DaisyJones 

 

Here is how you can do it. Get max and generate 12 months from there

Workflow:

atcodedog05_0-1641813115445.png

 

Hope this helps : )

DaisyJones
8 - Asteroid

This is great, I knew I just needed an extra pair of eyes on this! Thank you so much

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @DaisyJones 

Cheers and have a nice day!

Labels