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 SubjectDateAndrewPhysics1/1/2016LisaChemistry1/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 SubjectDateAndrewPhysics1/1/2016AndrewPhysics1/2/2016AndrewPhysics1/3/2016AndrewPhysics1/4/2016AndrewPhysics1/5/2016AndrewPhysics1/6/2016AndrewPhysics1/7/2016AndrewPhysics1/8/2016AndrewPhysics1/9/2016AndrewPhysics1/10/2016AndrewPhysics1/11/2016AndrewPhysics1/12/2016AndrewPhysics1/1/2017AndrewPhysics1/2/2017AndrewPhysics1/3/2017AndrewPhysics1/4/2017AndrewPhysics1/5/2017AndrewPhysics1/6/2017AndrewPhysics1/7/2017AndrewPhysics1/8/2017AndrewPhysics1/9/2017AndrewPhysics1/10/2017AndrewPhysics1/11/2017AndrewPhysics1/12/2017AndrewPhysics1/1/2018AndrewPhysics1/2/2018AndrewPhysics1/3/2018AndrewPhysics1/4/2018AndrewPhysics1/5/2018AndrewPhysics1/6/2018LisaChemistry1/30/2016LisaChemistry1/2/2016LisaChemistry1/3/2016LisaChemistry1/4/2016LisaChemistry1/5/2016LisaChemistry1/6/2016LisaChemistry1/7/2016LisaChemistry1/8/2016LisaChemistry1/9/2016LisaChemistry1/10/2016LisaChemistry1/11/2016LisaChemistry1/12/2016LisaChemistry1/1/2017LisaChemistry1/2/2017LisaChemistry1/3/2017LisaChemistry1/4/2017LisaChemistry1/5/2017LisaChemistry1/6/2017LisaChemistry1/7/2017LisaChemistry1/8/2017LisaChemistry1/9/2017LisaChemistry1/10/2017LisaChemistry1/11/2017LisaChemistry1/12/2017LisaChemistry1/1/2018LisaChemistry1/2/2018LisaChemistry1/3/2018LisaChemistry1/4/2018LisaChemistry1/5/2018LisaChemistry1/6/2018 I am looking forward to a solution without implementing macros. REgards, Zaid

Looping

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	Subject	Date
Andrew	Physics	1/1/2016
Lisa	Chemistry	1/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	Subject	Date
Andrew	Physics	1/1/2016
Andrew	Physics	1/2/2016
Andrew	Physics	1/3/2016
Andrew	Physics	1/4/2016
Andrew	Physics	1/5/2016
Andrew	Physics	1/6/2016
Andrew	Physics	1/7/2016
Andrew	Physics	1/8/2016
Andrew	Physics	1/9/2016
Andrew	Physics	1/10/2016
Andrew	Physics	1/11/2016
Andrew	Physics	1/12/2016
Andrew	Physics	1/1/2017
Andrew	Physics	1/2/2017
Andrew	Physics	1/3/2017
Andrew	Physics	1/4/2017
Andrew	Physics	1/5/2017
Andrew	Physics	1/6/2017
Andrew	Physics	1/7/2017
Andrew	Physics	1/8/2017
Andrew	Physics	1/9/2017
Andrew	Physics	1/10/2017
Andrew	Physics	1/11/2017
Andrew	Physics	1/12/2017
Andrew	Physics	1/1/2018
Andrew	Physics	1/2/2018
Andrew	Physics	1/3/2018
Andrew	Physics	1/4/2018
Andrew	Physics	1/5/2018
Andrew	Physics	1/6/2018
Lisa	Chemistry	1/30/2016
Lisa	Chemistry	1/2/2016
Lisa	Chemistry	1/3/2016
Lisa	Chemistry	1/4/2016
Lisa	Chemistry	1/5/2016
Lisa	Chemistry	1/6/2016
Lisa	Chemistry	1/7/2016
Lisa	Chemistry	1/8/2016
Lisa	Chemistry	1/9/2016
Lisa	Chemistry	1/10/2016
Lisa	Chemistry	1/11/2016
Lisa	Chemistry	1/12/2016
Lisa	Chemistry	1/1/2017
Lisa	Chemistry	1/2/2017
Lisa	Chemistry	1/3/2017
Lisa	Chemistry	1/4/2017
Lisa	Chemistry	1/5/2017
Lisa	Chemistry	1/6/2017
Lisa	Chemistry	1/7/2017
Lisa	Chemistry	1/8/2017
Lisa	Chemistry	1/9/2017
Lisa	Chemistry	1/10/2017
Lisa	Chemistry	1/11/2017
Lisa	Chemistry	1/12/2017
Lisa	Chemistry	1/1/2018
Lisa	Chemistry	1/2/2018
Lisa	Chemistry	1/3/2018
Lisa	Chemistry	1/4/2018
Lisa	Chemistry	1/5/2018
Lisa	Chemistry	1/6/2018

I am looking forward to a solution without implementing macros.

REgards,

Zaid

Preparation

Accepted answers

danilang

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

Dan

looping.yxmd

All comments

Zaid

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

Name	Subject
Andrew	Physics
Lisa	Chemistry

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

Hi @Zaid

Dan

looping.yxmd

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157