topic Loading and Storing a qvd File results in different number of records in App Development

Loading and Storing a qvd File results in different number of records

draghici1109 — Wed, 21 May 2025 10:00:04 GMT

Hello,

I just have a pretty simple code:

COSP:

NoConcatenate

LOAD

OBJNR, //01

GJAHR, //05

KSTAR, //06

WRTTP AS Realisierungsgrad,

VERSN, //08

VRGNG, //09

BEKNZ, //10

PERBL, //11

WTG001,

WTG002,

WTG003,

WTG004,

WTG005,

WTG006,

WTG007,

WTG008,

WTG009,

WTG010,

WTG011,

WTG012,

WTG013,

WTG014,

WTG015,

WTG016,

WRTTP

FROM [..\DATA\$(vPraefixDateiName)-COSP.qvd] (qvd);

STORE COSP into [..\DATA\PROFIS\$(vPraefixDateiName)-COSP_AusQlik.qvd] (qvd);

And yet, the input qvd-File, which contain more Fields as the stored one, namely 733255 records, as I store it into the COSP_AusQlik.qvd file it does contain only 639661 records. By any means, including extensive tests sugested by ChatGPT :-), I cannot solve this problem. The COSP_AusQlik should have the same amount of records as the input qvd file.

Any ideas/workarounds?

Thank you in advance,

Alexandru

Re: Loading and Storing a qvd File results in different number of records

marcus_sommer — Wed, 21 May 2025 15:56:13 GMT

Maybe all field-values from your field-extract are NULL and therefore skipped from the load. I could imagine that an added recno() and rowno() in this load and/or here and in a full-load of the source may trace which records are there and which one are missing.

Re: Loading and Storing a qvd File results in different number of records

rwunderlich — Wed, 21 May 2025 21:41:59 GMT

"the input qvd-File, which contain more Fields as the stored one, namely 733255 records, as I store it into the COSP_AusQlik.qvd file it does contain only 639661 "

Where do you get these numbers from?

-Rob

Re: Loading and Storing a qvd File results in different number of records

draghici1109 — Thu, 22 May 2025 04:35:50 GMT

Hello Rob,

the different numbers of rows in the input and output qvd I get it from the EasyQlik QViewer Tool.

Kind Regards, Alexandru

Re: Loading and Storing a qvd File results in different number of records

Aditya_Chitale — Thu, 22 May 2025 05:17:03 GMT

@draghici1109 ,

If you are adding the rows as dimensions and then checking the count, the duplicated rows might show as a single entry thus reducing the count of rows. Try adding recno() as an additional field in your data before storing the qvd and then check if the count shows correctly.

Regards,

Aditya

Re: Loading and Storing a qvd File results in different number of records

marcus_sommer — Thu, 22 May 2025 05:34:42 GMT

I use QViewer or Q-Eye usually only for quick looks on the data-structures and meta-data and not for more detailed evaluations but I never noticed any strange behaviour. Therefore I think the shown number of records are correct.

Like above hinted would a quick load within a qvw and the extra record-counters showing the truth - how many records are there as well as which one are missing. If so I would look for NULL's ...

Re: Loading and Storing a qvd File results in different number of records

draghici1109 — Thu, 22 May 2025 09:22:20 GMT

Dear Marcus,

Dear Rob,

Dear Aditya,

thank your for your implication and support! This attitude is something that I highly value on our Qlik Forums.

Yet... it is embarrassing for me, and I sense a little bit of shame 😞 … as I found out, that the input file which I used was a false one. I chose the file COSP.qvd from the false directory. I am sorry!

Yet I want to conclude positively: I learned from your responses some important hints how to manage similar problems that might occur in the future.

Kind Regards, Alexandru