topic Re: Load statement not loading all rows in QlikView

Load statement not loading all rows

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

Hi,

I am trying to load data into a qvd or text file, but not all rows are getting loaded. The data source has about 700,000 rows, but only about 200,000 get loaded every time I execute the script, whether into a qvd or text file. There are no errors registered. Why is this happening?

I am using the basic load and store statement:

QVTable:
LOAD Column1,
Column2;
SQL SELECT Column1, Column2 FROM SQLTablename;

STORE QVTable INTO Drive:\Path\QVTable.csv (txt);

Re: Load statement not loading all rows

marcus_sommer — Thu, 02 May 2019 11:36:53 GMT

I think the cause is either your database-driver which couldn't handle all records and just skipped them instead of running into an error or your database didn't return more records maybe because of locking those records or any set restrictions in the possible number of records or any timeouts or something similar.

- Marcus

Re: Load statement not loading all rows

dapostolopoylos — Thu, 02 May 2019 13:38:39 GMT

Have you tried to execute your query on the database client to see haow many rows are returned?
Otherwise Marcus proposes seems right to my eyes

Re: Load statement not loading all rows

kwnkhn — Fri, 03 May 2019 08:28:52 GMT

Yes, on database client, it returns all rows.

Re: Load statement not loading all rows

kwnkhn — Fri, 03 May 2019 08:29:33 GMT

Checking on this...