Straight table data need to separate by row as batch wise

[#1]

Hi

I have raw data with 1000 records,my requirement is we have straight table with 600 rows in front End.Based on this chart i need to break the data like below

Batch1 (1-100 rows)

Batch2 (101-200 rows)

Batch3 (201-300 rows)

Batch4 (301-400 rows)

Batch5 (401-500 rows)

Batch6 (501-600 rows)

in frond end i need a list box:

Batch1

Batch2

Batch3

Batch4

Batch5

Batch6

if i click on Batch1 the first 100 rows(1-100 rows) should display,if i click on Batch2 the second 100 rows(101-200 rows) should display... in the straight table etc

thanks

[Peter_Cammaert]

Add this column definition to the LOAD statement that loads the 1000 records of raw data:

LOAD

    :

    'Batch' & ceil(RowNo()/100) AS BatchNumber,

    :

FROM ...

Best,

Peter

[#3]

Hi peter

thanks for reply.

I did same thing in scripting.it is pulling raw data as 10 batches which i don't required.i want only 6 batches the data which is there in the straight table not in the raw data becoz in the straight table only specified data is pulled using by expression that data should be divided into equal ranges.

Thanks