topic Re: Help plzzz *Join without common key* in QlikView https://community.qlik.com/t5/QlikView/Help-plzzz-Join-without-common-key/m-p/407814#M1155990 <HTML><HEAD></HEAD><BODY><P>Hello Aamir,</P><P></P><P>Use Concatenate.</P><P></P><P>AllCusts:</P><P>Load Customers as AllCusts,</P><P>From Table1;</P><P></P><P>Concatenate (AllCusts)</P><P>Load Reg_Customers as AllCusts,</P><P>From Table2;</P><P></P><P>Don't forget to drop the tables you no longer need.</P><P></P><P></P><P>Karl</P></BODY></HTML> Wed, 06 Feb 2013 00:30:09 GMT pover 2013-02-06T00:30:09Z Help plzzz *Join without common key* https://community.qlik.com/t5/QlikView/Help-plzzz-Join-without-common-key/m-p/407813#M1155989 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have got small problem I hope you guys might help me.</P><P></P><P>*I dont have field to join. Is there any way I could get what do I need?</P><P></P><P><SPAN style="text-decoration: underline;">Table1</SPAN>:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="87" style="width: 226px; border: 1px solid rgb(0, 0, 0); height: 69px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Key</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Customers</STRONG></SPAN></TH></TR><TR><TD><P>1</P></TD><TD>Cust1</TD></TR><TR><TD><P>2</P></TD><TD>Cust2</TD></TR><TR><TD>3</TD><TD>Cust3</TD></TR></TBODY></TABLE><P></P><P></P><P><SPAN style="text-decoration: underline;">Table2</SPAN>:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="87" style="width: 226px; border: 1px solid #000000; height: 69px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG><STRONG>Barcode</STRONG></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff; text-align: -webkit-center; background-color: #6690bc;">Reg_Customers</STRONG><BR /></TH></TR><TR><TD>B1</TD><TD>vid1</TD></TR><TR><TD>B2</TD><TD>vid2</TD></TR><TR><TD>B3</TD><TD>vid3</TD></TR></TBODY></TABLE><P></P><P>What do I need:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="168" style="width: 228px; border: 1px solid rgb(0, 0, 0); height: 170px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>AllCusts</STRONG></SPAN></TH></TR><TR><TD><P>Cust1</P></TD></TR><TR><TD>Cust2</TD></TR><TR><TD>Cust3</TD></TR><TR><TD>vid1</TD></TR><TR><TD>vid2</TD></TR><TR><TD>vid3</TD></TR></TBODY></TABLE><P></P><P>Thanks a ton in advance.</P><P></P><P>Regards,</P><P>Aamir</P></BODY></HTML> Wed, 06 Feb 2013 00:16:28 GMT https://community.qlik.com/t5/QlikView/Help-plzzz-Join-without-common-key/m-p/407813#M1155989 2013-02-06T00:16:28Z Re: Help plzzz *Join without common key* https://community.qlik.com/t5/QlikView/Help-plzzz-Join-without-common-key/m-p/407814#M1155990 <HTML><HEAD></HEAD><BODY><P>Hello Aamir,</P><P></P><P>Use Concatenate.</P><P></P><P>AllCusts:</P><P>Load Customers as AllCusts,</P><P>From Table1;</P><P></P><P>Concatenate (AllCusts)</P><P>Load Reg_Customers as AllCusts,</P><P>From Table2;</P><P></P><P>Don't forget to drop the tables you no longer need.</P><P></P><P></P><P>Karl</P></BODY></HTML> Wed, 06 Feb 2013 00:30:09 GMT https://community.qlik.com/t5/QlikView/Help-plzzz-Join-without-common-key/m-p/407814#M1155990 pover 2013-02-06T00:30:09Z Re: Help plzzz *Join without common key* https://community.qlik.com/t5/QlikView/Help-plzzz-Join-without-common-key/m-p/407815#M1155991 <HTML><HEAD></HEAD><BODY><P>Thanks for your help Karl <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Cheers !</P></BODY></HTML> Tue, 19 Feb 2013 04:26:15 GMT https://community.qlik.com/t5/QlikView/Help-plzzz-Join-without-common-key/m-p/407815#M1155991 2013-02-19T04:26:15Z