topic Storing data from multiple QVDs in QlikView https://community.qlik.com/t5/QlikView/Storing-data-from-multiple-QVDs/m-p/165864#M38029 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Tue, 25 Aug 2009 19:48:43 GMT 2009-08-25T19:48:43Z Storing data from multiple QVDs https://community.qlik.com/t5/QlikView/Storing-data-from-multiple-QVDs/m-p/165862#M38027 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P></P></BODY></HTML> Tue, 25 Aug 2009 18:32:31 GMT https://community.qlik.com/t5/QlikView/Storing-data-from-multiple-QVDs/m-p/165862#M38027 2009-08-25T18:32:31Z Storing data from multiple QVDs https://community.qlik.com/t5/QlikView/Storing-data-from-multiple-QVDs/m-p/165863#M38028 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I think you will need to do the following:</P><UL><LI>Load data from the QVD's into 2 separate tables.</LI><LI>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.</LI><LI>Store 3rd table into a new QVD.</LI></UL><P>Rgds, Amit.</P></BODY></HTML> Tue, 25 Aug 2009 18:46:54 GMT https://community.qlik.com/t5/QlikView/Storing-data-from-multiple-QVDs/m-p/165863#M38028 amit_shetty78 2009-08-25T18:46:54Z Storing data from multiple QVDs https://community.qlik.com/t5/QlikView/Storing-data-from-multiple-QVDs/m-p/165864#M38029 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Tue, 25 Aug 2009 19:48:43 GMT https://community.qlik.com/t5/QlikView/Storing-data-from-multiple-QVDs/m-p/165864#M38029 2009-08-25T19:48:43Z Storing data from multiple QVDs https://community.qlik.com/t5/QlikView/Storing-data-from-multiple-QVDs/m-p/165865#M38030 <HTML><HEAD></HEAD><BODY><P>Thank you, problem sorted.</P></BODY></HTML> Tue, 25 Aug 2009 22:47:22 GMT https://community.qlik.com/t5/QlikView/Storing-data-from-multiple-QVDs/m-p/165865#M38030 2009-08-25T22:47:22Z