topic Join two tables with different name key in QlikView https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-name-key/m-p/263298#M99046 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">Hello</SPAN><BR /><BR /><BR /><BR /><SPAN class="hps">I have</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">tables,</SPAN> <SPAN class="hps">for example</SPAN><SPAN>,</SPAN> <SPAN class="hps">the Customer table</SPAN> <SPAN class="hps">and the table</SPAN> <SPAN class="hps">Customer2</SPAN><SPAN>,</SPAN> <SPAN class="hps">the Customer table</SPAN> <SPAN class="hps">as the key</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">the fields CLIENT</SPAN><SPAN>, and the table</SPAN> <SPAN class="hps">Customer2</SPAN><BR /><BR /><SPAN class="hps">as the key</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">fields</SPAN> <SPAN class="hps">NOCLIENT</SPAN><SPAN>.</SPAN><BR /><BR /><BR /><BR /><SPAN class="hps">How to</SPAN> <SPAN class="hps">link these</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">tables?</SPAN><BR /><BR /><BR /><BR /><SPAN class="hps">thank you</SPAN><BR /><BR /><BR /><BR /><SPAN class="hps">Maurice</SPAN></SPAN></P></BODY></HTML> Wed, 10 Aug 2011 12:51:57 GMT 2011-08-10T12:51:57Z Join two tables with different name key https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-name-key/m-p/263298#M99046 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">Hello</SPAN><BR /><BR /><BR /><BR /><SPAN class="hps">I have</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">tables,</SPAN> <SPAN class="hps">for example</SPAN><SPAN>,</SPAN> <SPAN class="hps">the Customer table</SPAN> <SPAN class="hps">and the table</SPAN> <SPAN class="hps">Customer2</SPAN><SPAN>,</SPAN> <SPAN class="hps">the Customer table</SPAN> <SPAN class="hps">as the key</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">the fields CLIENT</SPAN><SPAN>, and the table</SPAN> <SPAN class="hps">Customer2</SPAN><BR /><BR /><SPAN class="hps">as the key</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">fields</SPAN> <SPAN class="hps">NOCLIENT</SPAN><SPAN>.</SPAN><BR /><BR /><BR /><BR /><SPAN class="hps">How to</SPAN> <SPAN class="hps">link these</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">tables?</SPAN><BR /><BR /><BR /><BR /><SPAN class="hps">thank you</SPAN><BR /><BR /><BR /><BR /><SPAN class="hps">Maurice</SPAN></SPAN></P></BODY></HTML> Wed, 10 Aug 2011 12:51:57 GMT https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-name-key/m-p/263298#M99046 2011-08-10T12:51:57Z Join two tables with different name key https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-name-key/m-p/263299#M99047 <HTML><HEAD></HEAD><BODY><P> check weither data of two filels are looking similar</P><P></P><P>if so the rename as same name </P><P></P><P></P><P>it will provide you solution</P></BODY></HTML> Wed, 10 Aug 2011 13:05:50 GMT https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-name-key/m-p/263299#M99047 SunilChauhan 2011-08-10T13:05:50Z Join two tables with different name key https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-name-key/m-p/263300#M99048 <HTML><HEAD></HEAD><BODY><P>Hi, Maurice.</P><P>I'm not sure if I understood your question, but you need to rename the fiels to create a link in QlikView. </P><P>For example:</P><P>1) </P><P></P><P>Customer: </P><P>Load Client, Phone, Email </P><P>From .... </P><P></P><P>Customer2</P><P>Load NOCLIENT as Client</P><P>Address, Rating</P><P>From... </P><P></P><P></P><P>or</P><P>2 ) </P><P>Customer: </P><P>Load Client, Phone, Email </P><P>From .... </P><P></P><P>left join(Customer)</P><P>Load NOCLIENT as Client,</P><P>Address, Rating</P><P>From... </P><P></P><P>Hope this helps, </P><P></P><P>Erich</P></BODY></HTML> Wed, 10 Aug 2011 13:07:04 GMT https://community.qlik.com/t5/QlikView/Join-two-tables-with-different-name-key/m-p/263300#M99048 erichshiino 2011-08-10T13:07:04Z