How to Load first 1 million records

[chinnu123]

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.

[its_anandrjs · Accepted solution]

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;

[prma7799]

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;

[Chanty4u]

Read this

https://skillforge.com/qlikview-limiting-record-loads-with-the-first-prefix/

[chinnu123]

Thanks Anand for your reply, It's working fine

Thanks,

Chinnu.

[its_anandrjs]

Thanks