topic Re: two tables concatenate/join in QlikView https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943713#M325226 <HTML><HEAD></HEAD><BODY><P>Hi;</P><P></P><P>Look at this sample <A href="https://community.qlik.com/docs/DOC-8114">JOIN sample</A><SPAN style="font-size: 10pt; line-height: 1.5em;">, here you have all the join function possibilities</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Joaquín<BR /></SPAN></P></BODY></HTML> Thu, 03 Dec 2015 09:28:01 GMT Joaquin_Lazaro 2015-12-03T09:28:01Z two tables join https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943712#M325225 <HTML><HEAD></HEAD><BODY><P>Hi, two tables to join with resident </P></BODY></HTML> Thu, 03 Dec 2015 09:18:52 GMT https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943712#M325225 2015-12-03T09:18:52Z Re: two tables concatenate/join https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943713#M325226 <HTML><HEAD></HEAD><BODY><P>Hi;</P><P></P><P>Look at this sample <A href="https://community.qlik.com/docs/DOC-8114">JOIN sample</A><SPAN style="font-size: 10pt; line-height: 1.5em;">, here you have all the join function possibilities</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Joaquín<BR /></SPAN></P></BODY></HTML> Thu, 03 Dec 2015 09:28:01 GMT https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943713#M325226 Joaquin_Lazaro 2015-12-03T09:28:01Z Re: two tables concatenate/join https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943714#M325227 <HTML><HEAD></HEAD><BODY><P>hello JoaquinLR</P><P>i am trying all the possibilites</P><P>but couldnot make it happen <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 03 Dec 2015 09:46:09 GMT https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943714#M325227 2015-12-03T09:46:09Z Re: two tables concatenate/join https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943715#M325228 <HTML><HEAD></HEAD><BODY><P>Hellos</P><P></P><P>BudgetTemp:</P><P><SPAN style="color: #ff0000;">Left Join (KPIFin)</SPAN></P><P>Load</P><P>*,</P><P>Mid(BudgetPeriod, 3,2) as Period</P><P>Resident Budget;</P><P>Drop table Budget;</P><P></P><P>I think you should write the sentence in red.</P><P></P><P>Regards</P><P>Joaquín</P></BODY></HTML> Thu, 03 Dec 2015 09:52:27 GMT https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943715#M325228 Joaquin_Lazaro 2015-12-03T09:52:27Z Re: two tables concatenate/join https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943716#M325229 <HTML><HEAD></HEAD><BODY><P>It seems, both the table have same column structure...</P><P></P><P>For auto concatenation both the table should have same column name else you need to force the concatenation.</P><P></P><P>What you want to do ?&nbsp; Join or concatenation?</P></BODY></HTML> Thu, 03 Dec 2015 09:54:52 GMT https://community.qlik.com/t5/QlikView/two-tables-join/m-p/943716#M325229 Anonymous 2015-12-03T09:54:52Z