BusinessObjects Board

Autogenerate insert value like excel

Hi,

I have 5 user 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.

I have no experience with Data Services, but perhaps you could create a variable based on the BIL column that uses the modulus operator?

Here a demo with SQL Server code.

Does that help at all?