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

Looping

Zaid
8 - Asteroid

First of all I would like to thank members of Alteryx Community because of whom, our problems get solved. Please pardon me, if the solution to my question has already been posted in some other thread.

 

I have an input data consisting of three columns,say,"Name","Subject","Date"

Name SubjectDate
AndrewPhysics1/1/2016
LisaChemistry1/1/2016

  

My challenge is that i would want to create 30 rows for each "name" and "Subject" combination,with the date incrementing by one month, which could have been possible with a foreach loop.The output that i am expecting should be like

 

Name SubjectDate
AndrewPhysics1/1/2016
AndrewPhysics1/2/2016
AndrewPhysics1/3/2016
AndrewPhysics1/4/2016
AndrewPhysics1/5/2016
AndrewPhysics1/6/2016
AndrewPhysics1/7/2016
AndrewPhysics1/8/2016
AndrewPhysics1/9/2016
AndrewPhysics1/10/2016
AndrewPhysics1/11/2016
AndrewPhysics1/12/2016
AndrewPhysics1/1/2017
AndrewPhysics1/2/2017
AndrewPhysics1/3/2017
AndrewPhysics1/4/2017
AndrewPhysics1/5/2017
AndrewPhysics1/6/2017
AndrewPhysics1/7/2017
AndrewPhysics1/8/2017
AndrewPhysics1/9/2017
AndrewPhysics1/10/2017
AndrewPhysics1/11/2017
AndrewPhysics1/12/2017
AndrewPhysics1/1/2018
AndrewPhysics1/2/2018
AndrewPhysics1/3/2018
AndrewPhysics1/4/2018
AndrewPhysics1/5/2018
AndrewPhysics1/6/2018
LisaChemistry1/30/2016
LisaChemistry1/2/2016
LisaChemistry1/3/2016
LisaChemistry1/4/2016
LisaChemistry1/5/2016
LisaChemistry1/6/2016
LisaChemistry1/7/2016
LisaChemistry1/8/2016
LisaChemistry1/9/2016
LisaChemistry1/10/2016
LisaChemistry1/11/2016
LisaChemistry1/12/2016
LisaChemistry1/1/2017
LisaChemistry1/2/2017
LisaChemistry1/3/2017
LisaChemistry1/4/2017
LisaChemistry1/5/2017
LisaChemistry1/6/2017
LisaChemistry1/7/2017
LisaChemistry1/8/2017
LisaChemistry1/9/2017
LisaChemistry1/10/2017
LisaChemistry1/11/2017
LisaChemistry1/12/2017
LisaChemistry1/1/2018
LisaChemistry1/2/2018
LisaChemistry1/3/2018
LisaChemistry1/4/2018
LisaChemistry1/5/2018
LisaChemistry1/6/2018


 I am looking forward to a solution without implementing macros.

 

REgards,

Zaid

 

3 REPLIES 3
Zaid
8 - Asteroid

Folks there is a small update. I do not have the "Date" column. the input data is 

Name Subject
AndrewPhysics
LisaChemistry

 

ANd in the output data i want dates to come starting from 1/1/2016 and the subsequent dates incremented by 1 month, 30 times, similar to the output mentioned earlier.

 

Thanks

 

 

 

danilang
19 - Altair
19 - Altair

Hi @Zaid

 

Here's a simple workflow that does what you want.  The key is to use the generate rows to generate the dates and increment by months.  It will work with any number of initial rows or columns.  The second text input is for the startdate, which is not included in your original data set

 

solution.png

 

Dan

Zaid
8 - Asteroid

Thanks @danilang. The solution u provided worked. 

 

Regards

Labels