topic Re: Getting first n records in QVD in QlikView

Getting first n records in QVD

deepakqlikview_123 — Thu, 17 Jul 2014 04:18:18 GMT

Hi All,

My database table size is too big,moreover it does not have index number.

Can you please suggest how to get first n records while creating QVD please suggest.

Thanks,

Deepak

SunilChauhan — Thu, 17 Jul 2014 04:23:21 GMT

Load *

from table name where Rowno()<100;

avinashelite — Thu, 17 Jul 2014 04:23:51 GMT

Hi Deepak,

At the script try like below:

First 100000 load * from tablename;

This will fetch you the first n records from the DB, then u can make the analysis.

Regards,

@vi