topic Re: Re: join in QlikView https://community.qlik.com/t5/QlikView/join/m-p/666692#M476213 <HTML><HEAD></HEAD><BODY><P>Hi in that case</P><P></P><P>use the below script attached.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 12 Jun 2014 12:30:35 GMT ashfaq_haseeb 2014-06-12T12:30:35Z join https://community.qlik.com/t5/QlikView/join/m-p/666689#M476210 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P>If qlikview joins two tables automatically based on the name of Columns, what is the function of the join keyword and how is it different from the auto join. </P></BODY></HTML> Thu, 12 Jun 2014 12:20:58 GMT https://community.qlik.com/t5/QlikView/join/m-p/666689#M476210 2014-06-12T12:20:58Z Re: join https://community.qlik.com/t5/QlikView/join/m-p/666690#M476211 <HTML><HEAD></HEAD><BODY><P>Hi Faisal,</P><P></P><P>Go through the below post.</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6562">http://community.qlik.com/docs/DOC-6562</A></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 12 Jun 2014 12:23:08 GMT https://community.qlik.com/t5/QlikView/join/m-p/666690#M476211 ashfaq_haseeb 2014-06-12T12:23:08Z Re: join https://community.qlik.com/t5/QlikView/join/m-p/666691#M476212 <HTML><HEAD></HEAD><BODY><P>Thank you for your response but I don't have a license. </P></BODY></HTML> Thu, 12 Jun 2014 12:26:48 GMT https://community.qlik.com/t5/QlikView/join/m-p/666691#M476212 2014-06-12T12:26:48Z Re: Re: join https://community.qlik.com/t5/QlikView/join/m-p/666692#M476213 <HTML><HEAD></HEAD><BODY><P>Hi in that case</P><P></P><P>use the below script attached.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 12 Jun 2014 12:30:35 GMT https://community.qlik.com/t5/QlikView/join/m-p/666692#M476213 ashfaq_haseeb 2014-06-12T12:30:35Z Re: join https://community.qlik.com/t5/QlikView/join/m-p/666693#M476214 <HTML><HEAD></HEAD><BODY><P>By Default qlikview specify outer join which is the same as Explicit Join statement.</P></BODY></HTML> Thu, 12 Jun 2014 12:31:49 GMT https://community.qlik.com/t5/QlikView/join/m-p/666693#M476214 2014-06-12T12:31:49Z Re: join https://community.qlik.com/t5/QlikView/join/m-p/666694#M476215 <HTML><HEAD></HEAD><BODY><P>Faisal,</P><P></P><P>QlikView doesn't automatically join tables, but it does associate them using common field names.</P><P></P><P>If you want to combine two tables into a single one, that's when you need to use the JOIN statement in your data load.</P><P></P><P>Marcus</P></BODY></HTML> Thu, 12 Jun 2014 12:47:17 GMT https://community.qlik.com/t5/QlikView/join/m-p/666694#M476215 marcus_malinow 2014-06-12T12:47:17Z Re: Re: join https://community.qlik.com/t5/QlikView/join/m-p/666695#M476216 <HTML><HEAD></HEAD><BODY><P>Thanks,</P><P>When you say "Qlikview associates the tables" does that mean speaking in sql terms, is it an inner join?</P></BODY></HTML> Thu, 12 Jun 2014 16:38:48 GMT https://community.qlik.com/t5/QlikView/join/m-p/666695#M476216 2014-06-12T16:38:48Z