Qlikview creates new table for each qvd file.

[#1]

I am in the process of using an extract and data model solution in qlikview to create reports for a department in my organization. I have an extract that takes each table from a database and puts them in designated folders as qvd files. I have it set so that it creates a new qvd everyday for each table. I then retrieve these qvd files in my data model script and make connections between them. An example of this is show below:

Table1:

LOAD

*

FROM

Table1\Table1_*.qvd(qvd);

Table2:

Left Keep (Table 1)

LOAD

*

FROM

Table2\Table2_*.qvd(qvd);

I have an issue where when I load more than one qvd for each table it will create a separate version of the table called Table1-2 or Table1-3 (depending on how many qvd files I import). Is there an easy way that I can fix this code to concatenate the data from these multiple qvd files onto the table they are associated with? Thank you.

[Anonymous]

Matthew,

Are the fields the same?  I'd rather not use *, better to be explicit:

Table1:

LOAD

     A,

     B,

     C

FROM Table1\Table1_*.qvd(qvd);

[#3]

I limit the fields in the extract before the qvd is created. I'm just using the * in the data model since I need all of the fields stored in each qvd,

[Anonymous]

OK, your answer implies that all Table1_*.qvd files have the same structure.

Questions:

Are you using QUALIFY anywherein the script?

Did you try only Table1, without loading Table2?

Can you upload the app?  Empty OK, only script matters.