community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Generate 1 record for each of the previous 12 months

Highlighted
Quasar

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

Alteryx Certified Partner
Alteryx Certified Partner

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

Quasar

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

 

Thank you @BenMoss

Labels