Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Splitting files

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

21 Replies
Not applicable
Author

thanks a lot jagan. working now

maxgro
MVP
MVP

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