topic Lines fetched info in App Development

Lines fetched info

user8 — Mon, 20 Dec 2021 21:38:40 GMT

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.

Re: Lines fetched info

Arthur_Fong — Mon, 09 Dec 2019 05:18:51 GMT

Is there any duplicates in the QVD?

Try:

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

Re: Lines fetched info

user8 — Mon, 09 Dec 2019 06:39:16 GMT

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

Re: Lines fetched info

Arthur_Fong — Mon, 09 Dec 2019 07:29:18 GMT

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);