Adding list made up of years

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!

Datasets

R Tool

Accepted answers

martinding

Hi @himam,

Is this what you want to achieve?

Example.yxmd

All comments

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

Hi @himam,

Is this what you want to achieve?

Example.yxmd

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!

unique.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703