Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Qlikview creates new table for each qvd file.

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.

3 Replies
mov
Esteemed Contributor III

Re: Qlikview creates new table for each qvd file.

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

Not applicable

Re: Qlikview creates new table for each qvd file.

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,

mov
Esteemed Contributor III

Re: Qlikview creates new table for each qvd file.

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.


Community Browser