Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Generate 1 record for each of the previous 12 months

ddiesel
13 - Pulsar
13 - Pulsar

We need to generate records for each of the preceding 12 months. We are using a Generate Rows tool, Formula tool, and Multi-Row Formula tool but we can't get the dates just right. I think it may be due to the the number of days per month.

 

Can you help us fix the attached workflow? Or suggest a better method?

 

RQCDate Suspected
ABC120410113/1/2018
ABC120410111/1/2018
ABC1204101112/1/2017
ABC1204101111/1/2017
ABC1204101110/1/2017
ABC120410119/1/2017
ABC120410118/1/2017
ABC120410117/1/2017
ABC120410116/1/2017
ABC120410115/1/2017
ABC120410114/1/2017
ABC120410113/1/2017
ABC132740113/1/2018
ABC132740111/1/2018

 

Thank you!

 

Tagging: @mocalvo

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

I see what you are trying to do here.

 

The simplest solution would be to use the datetime functions within the generate rows tool it's self.

 

Check out this solution.

 

Ben

ddiesel
13 - Pulsar
13 - Pulsar

I did not know you could use DateTime functions in the Generate Rows tool. So cool!

 

Thank you @BenMoss

Labels