Repeat values on every nth row of a column

[Anonymous]

Hi,

I want to create a column (lets name it as Sequence) which has value 1 on 1st, 6th, 11th, 16th.....and so on rows, value 2 on 2nd, 7th, 12th, 17th...and so on rows. Finally I want a sequence of 1 to 5 repeating till the end of row (see sample data attached).

Any help in this will be greatly appreciated.

[sunny_talwar]

May be this

Table:

LOAD RowNo() as RowNo,

  Mod(RowNo()-1, 5) + 1 as Sequence

AutoGenerate 20;

[9917mark]

@sunny_talwar  After 3 hours of searching I came across your solution. Thank you.