topic Re: Join Tables in QlikView https://community.qlik.com/t5/QlikView/Join-Tables/m-p/1344478#M413950 <HTML><HEAD></HEAD><BODY><P>Hi Luiz,</P><P>LOAD * From B;</P><P>Left Join</P><P>LOAD * From A;</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170875_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Regards,</P><P>Antonio</P></BODY></HTML> Thu, 20 Jul 2017 13:42:35 GMT antoniotiman 2017-07-20T13:42:35Z Join Tables https://community.qlik.com/t5/QlikView/Join-Tables/m-p/1344477#M413949 <HTML><HEAD></HEAD><BODY><P>Hey guys, I have a doubt.</P><P></P><P>I want to make a join between two tables, but without a key, for example (Table A + Table B = Table C):</P><P><STRONG><BR /></STRONG></P><P><STRONG>A:</STRONG></P><TABLE border="1" class="jiveBorder" height="73.18181824684143" style="border: 1px solid rgb(0, 0, 0); width: 193.181818246841px; height: 61.1818182468414px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Price</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2,95</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1,88</TD></TR></TBODY></TABLE><P></P><P><STRONG>B:</STRONG></P><TABLE border="1" class="jiveBorder" height="73.18181824684143" style="border: 1px solid rgb(0, 0, 0); width: 86.1818182468414px; height: 62.1818182468414px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Store</STRONG></TH></TR><TR><TD style="padding: 2px;">Store_1</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_2</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_3</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_4</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_5</SPAN></TD></TR></TBODY></TABLE><P></P><P><STRONG>C:</STRONG></P><TABLE border="1" class="jiveBorder" height="269.18181824684143" style="border: 1px solid rgb(0, 0, 0); width: 299.181818246841px; height: 255.181818246841px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Store</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_1</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">2,95</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_1</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">1,88</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_2</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">2,95</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_2</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">1,88</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_3</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">2,95</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_3</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">1,88</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_4</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">2,95</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_4</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">1,88</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_5</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">2,95</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">Store_5</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.63636302948px;">1,88</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 20 Jul 2017 13:34:44 GMT https://community.qlik.com/t5/QlikView/Join-Tables/m-p/1344477#M413949 2017-07-20T13:34:44Z Re: Join Tables https://community.qlik.com/t5/QlikView/Join-Tables/m-p/1344478#M413950 <HTML><HEAD></HEAD><BODY><P>Hi Luiz,</P><P>LOAD * From B;</P><P>Left Join</P><P>LOAD * From A;</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170875_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Regards,</P><P>Antonio</P></BODY></HTML> Thu, 20 Jul 2017 13:42:35 GMT https://community.qlik.com/t5/QlikView/Join-Tables/m-p/1344478#M413950 antoniotiman 2017-07-20T13:42:35Z