Looping
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @danilang. The solution u provided worked.
Regards