Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
Is there any duplicates in the QVD?
Try:
LOAD distinct
[Ref No],
[Name],
Date
FROM [lib://SRO.qvd] (qvd);
Tried with LOAD distinct but same error. No duplicates in QVD file.
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);