Adding list made up of years

[himam]

Hey everyone, I honestly am not sure how to describe what I am trying to do so I am just going to go and paste what I have and what I need to get. Previously it was being done by creating lists with the year and then mutating it onto the existing data. 

What I have

Segment1	Segment2	Segment3
Programs	ADV	LIA
Programs	ADV	PRO

What I want to get

Thanks once again in advance!

[jrgo]

HI @himam 

I'd recommend learning the Generate Rows tool. Here's an example which generates rows until the condition is not longer true.

[martinding · Accepted solution]

Hi @himam,

Is this what you want to achieve?

[himam]

Hi, Yes this is what I am looking to do. Except I tried doing this with a much set and got an error saying "There were more than 16 records in the course" I have attached the data I was using. Do you know what I can do differently to make it work? 

Thanks!

[martinding]

Hi @himam ,

Yes, that "error" is the result of a configuration in the Append Tool. 

If you go to the configuration and switch to one of the following, it will work: