topic Re: Connect tables with Loop in QlikView https://community.qlik.com/t5/QlikView/Connect-tables-with-Loop/m-p/94275#M766101 <HTML><HEAD></HEAD><BODY><P>Try this:</P><PRE __default_attr="javascript" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_1530257790738900" jivemacro_uid="_1530257790738900"> <P>Data:</P> <P>Load </P> <P>RecNo() As No,</P> <P>T1</P> <P>From Table1;</P> <P>Join</P> <P>Load </P> <P>RecNo() As No,</P> <P>T2</P> <P>From Table2;</P> </PRE><P></P><P>Result Table will have No, T1, T2 fields. You can drop No field by command </P></BODY></HTML> Fri, 29 Jun 2018 07:37:06 GMT Quy_Nguyen 2018-06-29T07:37:06Z Connect tables with Loop https://community.qlik.com/t5/QlikView/Connect-tables-with-Loop/m-p/94274#M766100 <HTML><HEAD></HEAD><BODY><P>Hi there. Can you help me to connect 2 tables with Loop row by row.</P><P></P><TABLE border="1" class="jiveBorder" height="70" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 84px; height: 72px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>T1</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD></TR><TR><TD style="padding: 2px;">B</TD></TR><TR><TD style="padding: 2px;">C</TD></TR><TR><TD style="padding: 2px;">D</TD></TR><TR><TD style="padding: 2px;">E</TD></TR><TR><TD style="padding: 2px;">F</TD></TR></TBODY></TABLE><P></P><TABLE border="1" class="jiveBorder" height="83" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 82px; height: 85px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>T2</STRONG></TH></TR><TR><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">32</TD></TR><TR><TD style="padding: 2px;">52</TD></TR><TR><TD style="padding: 2px;">55</TD></TR><TR><TD style="padding: 2px;">21</TD></TR><TR><TD style="padding: 2px;">7</TD></TR></TBODY></TABLE><P></P><P></P><P>There is no keyword for 2 tables. I just want that row1 to row1, row2 to row2...</P><TABLE border="1" class="jiveBorder" height="64" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 183px; height: 66px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>T1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>T2</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">32</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">52</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">55</TD></TR><TR><TD style="padding: 2px;">E</TD><TD style="padding: 2px;">21</TD></TR><TR><TD style="padding: 2px;">F</TD><TD style="padding: 2px;">7</TD></TR></TBODY></TABLE><P></P><P></P><P>I have too many rows. So I wll not use inline table.</P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Connect-tables-with-Loop/m-p/94274#M766100 tomcatxx 2020-11-25T16:16:04Z Re: Connect tables with Loop https://community.qlik.com/t5/QlikView/Connect-tables-with-Loop/m-p/94275#M766101 <HTML><HEAD></HEAD><BODY><P>Try this:</P><PRE __default_attr="javascript" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_1530257790738900" jivemacro_uid="_1530257790738900"> <P>Data:</P> <P>Load </P> <P>RecNo() As No,</P> <P>T1</P> <P>From Table1;</P> <P>Join</P> <P>Load </P> <P>RecNo() As No,</P> <P>T2</P> <P>From Table2;</P> </PRE><P></P><P>Result Table will have No, T1, T2 fields. You can drop No field by command </P></BODY></HTML> Fri, 29 Jun 2018 07:37:06 GMT https://community.qlik.com/t5/QlikView/Connect-tables-with-Loop/m-p/94275#M766101 Quy_Nguyen 2018-06-29T07:37:06Z