Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
Top Solution Authors