topic Re: Joining 3 tables in QlikView https://community.qlik.com/t5/QlikView/Joining-3-tables/m-p/595746#M684452 <HTML><HEAD></HEAD><BODY><P>Hi Erwin, Just join the tables on the right keys like below:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">OrderDetails:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderID,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderVoucherID</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">From <STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">OrderVouchers</STRONG> ;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN (OrderVouchers)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderID,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; CustomerID,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Orderdate,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderTotal</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">From <STRONG>Orders</STRONG>;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN&nbsp; (OrderDetails)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderVoucherID,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; CodeDate,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Value,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Code,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Online,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Additional</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">From <STRONG>Codes</STRONG> ;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please find the attached qvw for reference.</P></BODY></HTML> Mon, 17 Feb 2014 14:57:39 GMT 2014-02-17T14:57:39Z Joining 3 tables https://community.qlik.com/t5/QlikView/Joining-3-tables/m-p/595744#M684450 <HTML><HEAD></HEAD><BODY><P>Dear Community,</P><P></P><P>I've been busy with joining and concatenating, but I haven't found a solution yet.</P><P>Hopefully you can help me out.</P><P></P><P><STRONG>1) connecting table "OrderVouchers"</STRONG></P><P></P><P>OrderID OrderVoucherID Amount</P><P>1 1 10</P><P>2 2 20</P><P>3 3 20</P><P>36 36 12,5</P><P>36 37 12,5</P><P>37 38 15</P><P></P><P><STRONG>2) Orders</STRONG></P><TABLE><TBODY><TR><TD>OrderID</TD><TD>transactionID</TD><TD>CustomerID</TD><TD>CompanyID</TD><TD>Orderdate</TD><TD>OrderTotal</TD></TR><TR><TD>1</TD><TD>6</TD><TD>1</TD><TD>0</TD><TD>2-2-2014</TD><TD>10</TD></TR><TR><TD>2</TD><TD>9</TD><TD>2</TD><TD>0</TD><TD>3-2-2014</TD><TD>20</TD></TR><TR><TD>3</TD><TD>10</TD><TD>3</TD><TD>0</TD><TD>4-2-2014</TD><TD>20</TD></TR><TR><TD>36</TD><TD>34</TD><TD>2</TD><TD>0</TD><TD>12-2-2014</TD><TD>25</TD></TR><TR><TD>37</TD><TD>35</TD><TD>13</TD><TD>0</TD><TD>12-2-2014</TD><TD>15</TD></TR></TBODY></TABLE><P></P><P></P><P><STRONG>3 ) Codes</STRONG></P><P></P><TABLE><TBODY><TR><TD>Codes</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>OrderVoucherID</TD><TD>CodeID</TD><TD>Codedate</TD><TD>Value</TD><TD>Code</TD><TD>Online</TD><TD>Additional</TD></TR><TR><TD>1</TD><TD>1</TD><TD>0</TD><TD> € 10,00</TD><TD>x</TD><TD>1</TD><TD>0</TD></TR><TR><TD>2</TD><TD>2</TD><TD>0</TD><TD> € 20,00</TD><TD>y</TD><TD>1</TD><TD>0</TD></TR><TR><TD>3</TD><TD>3</TD><TD>0</TD><TD> € 20,00</TD><TD>z</TD><TD>1</TD><TD>0</TD></TR><TR><TD>36</TD><TD>36</TD><TD>0</TD><TD> € 12,50</TD><TD>b</TD><TD>1</TD><TD>0</TD></TR><TR><TD>37</TD><TD>37</TD><TD>0</TD><TD> € 12,50</TD><TD>c</TD><TD>0</TD><TD>0</TD></TR><TR><TD>38</TD><TD>38</TD><TD>0</TD><TD> € 15,00</TD><TD>d</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P></P><P></P><P><STRONG>The wanted output must be:</STRONG></P><P></P><TABLE><TBODY><TR><TD>OrderID</TD><TD>OrderVoucherID</TD><TD>CustomerID</TD><TD>Orderdate</TD><TD>Codedate</TD><TD>OrderTotal</TD><TD>Value</TD><TD>Code</TD><TD>Online</TD><TD>Additional</TD></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD><TD>2-2-2014</TD><TD>0</TD><TD>10</TD><TD> € 10,00</TD><TD>x</TD><TD>1</TD><TD>0</TD></TR><TR><TD>2</TD><TD>2</TD><TD>2</TD><TD>3-2-2014</TD><TD>0</TD><TD>20</TD><TD> € 20,00</TD><TD>y</TD><TD>1</TD><TD>0</TD></TR><TR><TD>3</TD><TD>3</TD><TD>3</TD><TD>4-2-2014</TD><TD>0</TD><TD>20</TD><TD> € 20,00</TD><TD>z</TD><TD>1</TD><TD>0</TD></TR><TR><TD>36</TD><TD>36</TD><TD>2</TD><TD>12-2-2014</TD><TD>0</TD><TD>25</TD><TD> € 12,50</TD><TD>b</TD><TD>1</TD><TD>0</TD></TR><TR><TD>36</TD><TD>37</TD><TD>2</TD><TD>12-2-2014</TD><TD>0</TD><TD>25</TD><TD> € 12,50</TD><TD>c</TD><TD>0</TD><TD>0</TD></TR><TR><TD>37</TD><TD>38</TD><TD>13</TD><TD>12-2-2014</TD><TD>0</TD><TD>15</TD><TD> € 15,00</TD><TD>d</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P></P><P>So 1 order can have multiple vouchers.</P><P>It would be perfect to join the columns Orderdate and Codedate, because when one is filled with a date the other isn't, and visa versa.</P><P></P><P>Hope my question is clear. If there are any questions, let me know.</P><P></P><P>Kind regards,</P><P></P><P>Erwin</P></BODY></HTML> Mon, 17 Feb 2014 14:29:03 GMT https://community.qlik.com/t5/QlikView/Joining-3-tables/m-p/595744#M684450 2014-02-17T14:29:03Z Re: Joining 3 tables https://community.qlik.com/t5/QlikView/Joining-3-tables/m-p/595745#M684451 <HTML><HEAD></HEAD><BODY><P>As far as I can tell you can do the following to get the exact same output table as per above</P><P></P><P>OrderVouchers:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OrderID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OrderVoucherID</P><P>From ....</P><P></P><P>LEFT JOIN (OrderVouchers)</P><P>Orders:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OrderID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; CustomerID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Orderdate,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OrderTotal</P><P>From ...</P><P></P><P>LEFT JOIN&nbsp; (OrderVouchers)</P><P>Codes:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OrderVoucherID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; CodeDate,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Value,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Code,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Online,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Additional</P><P>From ...</P><P></P><DIV> </DIV></BODY></HTML> Mon, 17 Feb 2014 14:44:12 GMT https://community.qlik.com/t5/QlikView/Joining-3-tables/m-p/595745#M684451 2014-02-17T14:44:12Z Re: Joining 3 tables https://community.qlik.com/t5/QlikView/Joining-3-tables/m-p/595746#M684452 <HTML><HEAD></HEAD><BODY><P>Hi Erwin, Just join the tables on the right keys like below:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">OrderDetails:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderID,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderVoucherID</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">From <STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">OrderVouchers</STRONG> ;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN (OrderVouchers)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderID,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; CustomerID,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Orderdate,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderTotal</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">From <STRONG>Orders</STRONG>;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN&nbsp; (OrderDetails)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; OrderVoucherID,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; CodeDate,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Value,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Code,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Online,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Additional</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">From <STRONG>Codes</STRONG> ;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please find the attached qvw for reference.</P></BODY></HTML> Mon, 17 Feb 2014 14:57:39 GMT https://community.qlik.com/t5/QlikView/Joining-3-tables/m-p/595746#M684452 2014-02-17T14:57:39Z