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

Duplicating Rows While Changing Year

Nathan_Boynton
7 - Meteor

Hi Everyone,

 

I am trying to duplicate rows, while advancing the year value in my dataset. 

 

This is the dataset that I am starting with:

Nathan_Boynton_0-1626792423800.png

 

This is what I would like to end up with:

Nathan_Boynton_1-1626792468854.png

 

I am able to copy the new rows using the Generate Rows tool, but I am unsure how to advance the year forward in a loop in the Generate Rows tool. 

 

I have attached the dataset input and output to the post. 

 

Any help would be greatly appreciated! Thanks so much! 

 

Best,

 

Nathan 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @Nathan_Boynton 

 

Generate row tool config will be something like below.

 

atcodedog05_0-1626792938540.png

 

Hope this helps : )

 

Nathan_Boynton
7 - Meteor

@atcodedog05 You rock! Thank you so much!

Hongli1216
8 - Asteroid

Hi @atcodedog05,  I used the Generate row, but I got the below error message. Please advise! Thanks!

Holly

Hongli1216_0-1633545847704.png

 

Hongli1216
8 - Asteroid

I fixed it. Thanks!

Holly

Labels