Generating Break (Predefined) Numbers in Sequence.

[HirisH_V7]

Hi Qlikers,

I was trying achieve below, help me out. I want to create this To Generate Column in script with my data column No ,how it can be possible. 

As i am already having limit stored in   Let VConNumLimit=5; .

No	To Generate
1	1
1	2
1	3
1	4
1	5
1	1
1	2
2	3
2	4
2	5
2	1
2	2
2	3
2	4
2	5
2	1
1	2
2	3
3	4
1	5
2	1
3	2
1	3
1	4
2	5
2	1
3	2
3	3

Pl Help me out, Attached the excel file for ref.

Thanks in advance,

Hirish

[Gysbert_Wassenaar · Accepted solution]

Mod(RecNo()-1, $(vConNumLimit))+1 as [To Generate]