Autogenerate insert value like excel

Question

Hi,

I have 8 group name to insert to 1000 row repeatably. How to do it in Data Services to generate automatically the 5 username insert to 1000 row ?

thanks.

Answer 1

Not sure what you mean with Data Services, but there are so many products in the Data Platform sphere, I can't keep track of them all.

In plain SQL query you can do:

SELECT BIL, POSKOD, STATUS, KETERANGAN, LOKASI, 
        row_number() OVER(ORDER BY BIL) / % 8 + 1
FROM  tbl

The row_number function numbers the rows ordered by what you specify in the ORDER BY clause. % is the modulus operator.