Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
chinnu123
Creator
Creator

How to Load first 1 million records

Hi Team,

I have a QVD having 17 million records so I need to load only 1 million records from QVD.

Can any one tell me how to achieve this?

Thanks,

Chinnu.

1 Solution

Accepted Solutions
its_anandrjs

Use First before load statement

Ex:-

First 10000

Load

*

From Source;

And for you solution First to be place on before load statement

First 1000000

Load

*

From Source;

View solution in original post

8 Replies
its_anandrjs

Use First before load statement

Ex:-

First 10000

Load

*

From Source;

And for you solution First to be place on before load statement

First 1000000

Load

*

From Source;

Anil_Babu_Samineni

May be this?

FIRST 1000000

Load * From Qvd;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
prma7799
Master III
Master III

Try like

First 1000000

Load *

From ABC ;

its_anandrjs

Or another way is

Load

*

From Source Where Rowno() <= 1000000;

its_anandrjs

OR By first key word also

First 1000000

Load

*

From Source;

chinnu123
Creator
Creator
Author

Thanks Anand for your reply, It's working fine

Thanks,

Chinnu.

its_anandrjs

Thanks