Lines fetched info

[user8]

Hi,

I'm loading a QVD file with below command:

LOAD 
[Ref No],
[Name],
Date
FROM [lib://SRO.qvd] (qvd);

Started loading data
SRO
(QVD (row-based) optimized)
Lines fetched: 3,504
Creating search index
Search index creation completed successfully
App saved
Finished successfully

The results show 3,504 lines fetched but when I view the QVD file it only has 1,174 lines/rows.
Why does the LOAD script says 3,504 lines when it has only 1,174 lines in the QVD?

Thank you.

[Arthur_Fong]

Is there any duplicates in the QVD?

Try:

LOAD distinct
[Ref No],
[Name],
Date
FROM [lib://SRO.qvd] (qvd);

[user8]

Tried with LOAD distinct but same error.  No duplicates  in QVD file.

[Arthur_Fong · Accepted solution]

Is there any tables with the same columns loaded previously in the script?

Tables with same columns are auto-concatenated when reloading.

To avoid this, try:

noconcatenate
LOAD distinct
[Ref No],
[Name],
Date
FROM [lib://SRO.qvd] (qvd);