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: 
Anonymous
Not applicable

qvd separation?

i have  2 cro records in one qvd but i want load this qvd for multiple times in the way

first   1cro in one table and   next  1 cro in another table ? how?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like:

Qvd1:

First 10000000 Load * From <qvd>;
Store Qvd1 Into <>;

Drop table Qvd1;

Qvd2:

Load * From <qvd> where RecNo()>10000000;

Store Qvd2 into <>;

Drop Table Qvd2;

View solution in original post

2 Replies
tresesco
MVP
MVP

May be like:

Qvd1:

First 10000000 Load * From <qvd>;
Store Qvd1 Into <>;

Drop table Qvd1;

Qvd2:

Load * From <qvd> where RecNo()>10000000;

Store Qvd2 into <>;

Drop Table Qvd2;

Not applicable
Author

hi

try according to this

FIRST 10000000 LOAD * from test.qvd (qvd);