Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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
This doesn't necessarily address your question, but I would recommend reading the article below. It proved to be quite helpful for me.
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.