Storing data from multiple QVDs

[#1]

I have one QVD which shows ordered detail and another which shows despatch detail I want to load these into QlikView and store the result into one single QVD which will show the figures that relate. I have tried Concatenate but this only does as the name suggests and puts all the lines into one table, with no relationships applied.

[amit_shetty78]

Hi,

I think you will need to do the following:

• Load data from the QVD's into 2 separate tables.
• Then join the 2 resident tables based on the relationship/s and conditions if you have any and load the resultant into a 3rd table.
• Store 3rd table into a new QVD.

Rgds, Amit.

[#3]

I don't understand why you can't just use the relationships anyway, if the tables are related then QlikView will join them, what is the problem with this?

[#4]

Thank you, problem sorted.