How to split data into separate qvd after ever 250 record read ?

[shekhar_analyti]

Hi All ,

I have two scenarios of splitting data in separate qvd ;

1) Split data in separate qvd based on country . For example if i have total of 10 countries then , 10 qvds should be formed with data of respective countries only.

2) Irrespective of country , four set of qvd should be created with each having 250 records . Something like first 250 records in one qvd , next 250 in others .. **

I have attached sample data which is having 1000 records .

[shekhar_analyti]

Hi Sushil ,

Above script helped me for my requirement .

But Please help me understand that why you have used

Temp:

LOAD Max(1),

     Country

FROM

[Drug Sales.xlsx]

(ooxml, embedded labels, table is data)

Group by Country;

Why not only below script .

------------------------------------Script2--------------------------

Temp:

LOAD

     Country

FROM

[Drug Sales.xlsx]

(ooxml, embedded labels, table is data)

Group by Country;

I tried executing script 2 but its giving error  : Aggregation expressions required by GROUP BY clause