topic Help :) Connect Tables in QlikView https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431772#M160968 <HTML><HEAD></HEAD><BODY><P>I have two tables:</P><P></P><P>Table1:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PartnerID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PartnerName</P><P></P><P>Table2:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OrderID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PartnerID1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PartnerID2,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Quantity</P><P></P><P>How can I connect both Partners from Table2 with Table1?</P></BODY></HTML> Thu, 17 Jan 2013 16:27:51 GMT farolito20 2013-01-17T16:27:51Z Help :) Connect Tables https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431772#M160968 <HTML><HEAD></HEAD><BODY><P>I have two tables:</P><P></P><P>Table1:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PartnerID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PartnerName</P><P></P><P>Table2:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OrderID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PartnerID1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PartnerID2,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Quantity</P><P></P><P>How can I connect both Partners from Table2 with Table1?</P></BODY></HTML> Thu, 17 Jan 2013 16:27:51 GMT https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431772#M160968 farolito20 2013-01-17T16:27:51Z Re: Help :) Connect Tables https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431773#M160969 <HTML><HEAD></HEAD><BODY><P>Table1:</P><P>PartnerID,</P><P>PartnerName</P><P></P><P>Table2:</P><P>OrderID,</P><P>PartnerID1 as PartnerID,</P><P>PartnerID2,</P><P>Quantity</P></BODY></HTML> Thu, 17 Jan 2013 16:28:48 GMT https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431773#M160969 2013-01-17T16:28:48Z Re: Help :) Connect Tables https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431774#M160970 <HTML><HEAD></HEAD><BODY><P>What about <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">PartnerID2?</SPAN></P></BODY></HTML> Thu, 17 Jan 2013 16:29:38 GMT https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431774#M160970 farolito20 2013-01-17T16:29:38Z Re: Help :) Connect Tables https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431775#M160971 <HTML><HEAD></HEAD><BODY><P>Use mapping:</P><P></P><P>PartnerMap:<BR /><STRONG>MAPPING </STRONG>LOAD DISTINCT<BR />&nbsp;&nbsp;&nbsp;&nbsp; PartnerID as A,<BR />&nbsp;&nbsp;&nbsp;&nbsp; PartnerName as B<BR />RESIDENT Table1;</P><P><BR />Drop Table Table1</P><P>Table2:<BR />LOAD<BR /> OrderID,<BR /> <STRONG>applymap</STRONG>('PartnerMap',PartnerID1) as Partner1,<BR /> <STRONG>applymap</STRONG>('PartnerMap',PartnerID2) as Partner2,<BR /> ...</P></BODY></HTML> Tue, 22 Jan 2013 16:32:59 GMT https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431775#M160971 Anonymous 2013-01-22T16:32:59Z Re: Help :) Connect Tables https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431776#M160972 <HTML><HEAD></HEAD><BODY><P>This only work with two fields?</P></BODY></HTML> Tue, 22 Jan 2013 17:05:36 GMT https://community.qlik.com/t5/QlikView/Help-Connect-Tables/m-p/431776#M160972 farolito20 2013-01-22T17:05:36Z