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