Loading QVD give much more records

[francisvandergr]

Today i am first working with QVD's. what is my challenge. I want to compare current data with data from the past. Every day i made a qvd file with the data from that moment (i think). So i have some QVD's.

In my source QVW i have 200 records in a table. When i make a qvd of this table and load in it in a new QVW i have 45990 records. Does anybody know how this is possible ? I load one qvd

[Miguel_Angel_Baeyens]

Hello Francis,

Can you post some of your code where you store those QVDs and how you load them? Are you concatenating, joining some tables?

Regards.

[francisvandergr]

Her i have my script. Thanx for your reaction

[Miguel_Angel_Baeyens]

Hello Francis,

I see you do after the binary load a loop to store some tables into QVD files. Is taht loop correct (not the syntax, but the tables it has)? Does the creator script store proper number of records? This is easy to check, create a new file and open just one of the QVDs you have previously created.

In the creator, are you concatenating explicit or implicit or doing any partial reload, or join?

Hope that helps.

[francisvandergr]

Sorry but i think i don't understand you. The qvd's that are created are good. All tables from the source qvw comes in a filestore with the extension QVD.

One file of those QVD's i load in a new file. And then i see that there are much more records. What do you mean with the creator, is that the source from where the QVD's are made ?

[francisvandergr]

i concatenate nothing and join nothing when i load the qvd's. I load one table

[Miguel_Angel_Baeyens]

Francis,

In the text file you attached above, you are doing a binary load, so you are loading all its records into a new document, and this document will have the same tables and records you have in the other document. Then you do a loop to store each of them into a QVD file. Then you do another loop to drop all of them.

My question is about that QVW file you are binary loading, how the data is built in there and if there is a chance that some records are being loaded several times.

At the end of the txt you posted you are loading using wilcards instead the name of the file alone. By itself that's okay, but depending on the name of the files (for example, timestamps), that means you can be loading several files, so there you are the lots of records. Is that possible?

\\FS01\303327$\data\QlikView\Werkkapitaal_Historie\Historie\24*werk*.QV

If you have more than one file that starts with "24" and has "werk" in its name, then you are loading actually more than one file, so it's likely you will find more records that in one file alone.

Sorry if I didn't myself clear before.

Hope that helps.

[francisvandergr]

Hi Miquel,

Thanx for your answer. I have enclosed my script so you can see it. I load one QVD. I understand that there is a possibility that there are more files, but that is not so.

[Miguel_Angel_Baeyens]

Hi Francis,

The file appears to be empty.

Regards.

[francisvandergr]

Miquel,

Here i send you a new file. This is not empty.

Gr

francis