Incrementing Rows by 1 and Generating the Rows

whitkrieng

I have a dataset that looks like this:  

Need help on something that I thought would be straightforward with generating rows.  I just need to create additional rows incrementing +1 from the column "DateGroup". So basically, I would get additional rows of 0, 1, 2, down to the line while retaining the "Consumer_30Day_ID".  So as I increment 0,1,2 down to 31, those would rows would still have "Consumer_30DayID" as 1 as shown then next set increments from 31 and so on: 

Thanks for your help.  

Increment by 1 Example.yxmd

AngelosPachis

Hi @whitkrieng ,

A slightly different take than @purnimat  one, I used a multi-row formula tool to find at which date group you should stop generating rows for each consumer-30Day_ID. Then I used the generate rows tool, to create those extra rows.

Hope that helps,

Cheers

Angelos

Increment by 1 Example_v1.yxmd