different info on load vs table count

[#1]

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

[MK_QSL]

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?

[#3]

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

[#4]

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?

[pgrenier · Accepted solution]

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

[#6]

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