topic How to Load first 1 million records in QlikView

How to Load first 1 million records

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to Load first 1 million records

its_anandrjs — Thu, 14 Sep 2017 07:03:13 GMT

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;

Re: How to Load first 1 million records

Anil_Babu_Samineni — Thu, 14 Sep 2017 07:03:15 GMT

May be this?

FIRST 1000000

Load * From Qvd;

Re: How to Load first 1 million records

prma7799 — Thu, 14 Sep 2017 07:03:18 GMT

Try like

First 1000000

Load *

From ABC ;

Re: How to Load first 1 million records

its_anandrjs — Thu, 14 Sep 2017 07:04:33 GMT

Or another way is

Load

From Source Where Rowno() <= 1000000;

Re: How to Load first 1 million records

its_anandrjs — Thu, 14 Sep 2017 07:05:10 GMT

OR By first key word also

First 1000000

Load

From Source;

Re: How to Load first 1 million records

Chanty4u — Thu, 14 Sep 2017 07:06:57 GMT

Read this

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

Re: How to Load first 1 million records

chinnu123 — Thu, 14 Sep 2017 07:11:49 GMT

Thanks Anand for your reply, It's working fine

Thanks,

Chinnu.

Re: How to Load first 1 million records

its_anandrjs — Thu, 14 Sep 2017 07:15:23 GMT

Thanks