Duplicating Rows While Changing Year

[Nathan_Boynton]

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:

This is what I would like to end up with:

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 

[atcodedog05 · Accepted solution]

Hi @Nathan_Boynton 

Generate row tool config will be something like below.

Hope this helps : )

[Nathan_Boynton]

@atcodedog05 You rock! Thank you so much!

[Hongli1216]

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

Holly

[Hongli1216]

I fixed it. Thanks!

Holly