Splitting files

[#1]

Hi Experts,

I have a pivot table with 8764 lines of records.

I need to split into sub files with 900 lines of records each.

Is it possible?

pls give suggestions

[#2]

thanks a lot jagan. working now

[maxgro]

I used these lines 

// test data

Data:

LOAD

RowNo() AS RowNum

AutoGenerate 8764;

to check my answer and verify the 10 qvd were created

Just replace with your load from qvd or excel or etc.....; you need a RowNum field as in my script