topic different info on load vs table count in QlikView

different info on load vs table count

Tue, 22 Apr 2014 16:46:25 GMT

Hello,

When i load data i can see my load script is counting the rows. When it stops it says 85000 rows. If i hoover over my table it says only 75777.

How come there is a difference? I am loading from a QVD file.

Thanks

Re: different info on load vs table count

MK_QSL — Tue, 22 Apr 2014 16:49:18 GMT

Try to add one more line in load script

RowNO() as No,

Now check, are you facing the same issue?

Also, have you add any condition on QVD load?

Re: different info on load vs table count

Tue, 22 Apr 2014 17:04:52 GMT

Now my table has 85000 values (but this is wrong, there should only be 75000 as before) - I have an condition where i only load one customer (the orginal QVD consists of serveral customers)

My tables which is wrong is resident load of the QVD with a where statement

Re: different info on load vs table count

Tue, 22 Apr 2014 17:14:40 GMT

I can see if i put the rows in a table box some rows exists twice - so there is dublets. But i do a distinct in my resident load, so i really dont get it?

Re: different info on load vs table count

pgrenier — Tue, 22 Apr 2014 17:19:49 GMT

Hello Thomas,

The DISTINCT option does not prevent QlikView from reading the data, simply from inserting it in the new table. Therefore, if your source table has 85000 rows, 85000 rows shall be read, then filtered down to the 75000 distinct values.

Regards,

Philippe

Re: different info on load vs table count

Tue, 22 Apr 2014 17:23:22 GMT

Ahhhhh - Of cause - Great observation (stupid me) Thank you