Alteryx Designer Desktop Discussions

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

Generate dynamic 12 months rows

DaisyJones
Asteroide

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 RESPOSTAS 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
Asteroide

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!

Enquetes
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Rótulos