Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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