Loading multiple qvd files into one table

[#1]

In my data model I am taking several qvd files created in my extract, and loading them into the same table. For some reason qlikview is creating a separate table for each qvd rather than just concatenating them onto each other. Is there a keyword that I can use in the code shown to prevent qlikview from creating multiple tables for each qvd? Thanks.

Table1:

LOAD

Field1,

Field2,

Field3

FROM

Table1\Table1_*.qvd(qvd);

Table2:

Inner Keep (Table1)

LOAD

Field1,

Field4,

Field5

FROM

Table2\Table2_*.qvd(qvd);

[PradeepReddy]

Keep -  retains the tables as it is with the resultant rows.

We can achieve this using

1) Left/Right/Inner Join 

     Check the Parent-Child relation ship and join the tables based on the primary keys.

2) Concatinate

Regards,

Pradeep

[jlongoria]

This doesn't necessarily address your question, but I would recommend reading the article below. It proved to be quite helpful for me.

Understanding Join, Keep and Concatenate

[erikzions]

You more than likely have some Qualify applied.  This is making a different table for each load.  The * in your load is creating a loop.  Thus each QVD is making a new qualified table.  Try adding a Unqualify * before your load.  Then if you still need it qualified, load into a second table afterwards.