topic Re: combining 2 table in QlikView https://community.qlik.com/t5/QlikView/combining-2-table/m-p/78077#M778373 <HTML><HEAD></HEAD><BODY><P>May be this?</P></BODY></HTML> Mon, 23 Apr 2018 10:44:57 GMT shiveshsingh 2018-04-23T10:44:57Z combining 2 table https://community.qlik.com/t5/QlikView/combining-2-table/m-p/78074#M778370 <HTML><HEAD></HEAD><BODY><P>Trying to combine 2 table, both got the right order , so just need to combine line per line:</P><P></P><P><IMG alt="23-04-2018 11-23-04.png" class="jive-image image-1" src="/legacyfs/online/200506_23-04-2018 11-23-04.png" style="height: auto;" /></P><P></P><P>Thanks,</P><P></P><P>Raphael</P><P></P><P><SPAN style="font-size: 13.3333px;">MyNames:</SPAN></P><P><SPAN style="font-size: 13.3333px;">LOAD * INLINE [</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name, Date</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jim, 01/01/2010</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Dan, 01/01/2010</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Laura, 01/01/2010</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jim, 20/01/2010</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Dan, 20/01/2010</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Laura, 20/01/2010</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jim, 25/01/2010</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Dan, 25/01/2010</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Laura, 25/01/2010</SPAN></P><P><SPAN style="font-size: 13.3333px;">];</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Concatenate (MyNames)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">MyGrades:</SPAN></P><P><SPAN style="font-size: 13.3333px;">LOAD * INLINE [</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Name, Grade</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jim, 10</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Dan, 20</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Laura, 30</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jim, 100</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Dan, 200</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Laura, 300</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jim, 1000</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Dan, 1000</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Laura, 1000</SPAN></P><P><SPAN style="font-size: 13.3333px;">];</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/combining-2-table/m-p/78074#M778370 Anonymous 2020-11-25T16:16:04Z Re: combining 2 table https://community.qlik.com/t5/QlikView/combining-2-table/m-p/78075#M778371 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try with:</P><P></P><P>MyNames:</P><P>LOAD </P><P>&nbsp; Name,</P><P>&nbsp; Date,</P><P>&nbsp; RowNo() as id</P><P>INLINE [</P><P>&nbsp;&nbsp;&nbsp; Name, Date</P><P>&nbsp;&nbsp;&nbsp; Jim, 01/01/2010</P><P>&nbsp;&nbsp;&nbsp; Dan, 01/01/2010</P><P>&nbsp;&nbsp;&nbsp; Laura, 01/01/2010</P><P>&nbsp;&nbsp;&nbsp; Jim, 20/01/2010</P><P>&nbsp;&nbsp;&nbsp; Dan, 20/01/2010</P><P>&nbsp;&nbsp;&nbsp; Laura, 20/01/2010</P><P>&nbsp;&nbsp;&nbsp; Jim, 25/01/2010</P><P>&nbsp;&nbsp;&nbsp; Dan, 25/01/2010</P><P>&nbsp;&nbsp;&nbsp; Laura, 25/01/2010</P><P>];</P><P></P><P></P><P>Left Join</P><P></P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; Name,</P><P>&nbsp;&nbsp;&nbsp; Grade,</P><P>&nbsp;&nbsp;&nbsp; RowNo() as id</P><P> INLINE [</P><P>&nbsp;&nbsp;&nbsp; Name, Grade</P><P>&nbsp;&nbsp;&nbsp; Jim, 10</P><P>&nbsp;&nbsp;&nbsp; Dan, 20</P><P>&nbsp;&nbsp;&nbsp; Laura, 30</P><P>&nbsp;&nbsp;&nbsp; Jim, 100</P><P>&nbsp;&nbsp;&nbsp; Dan, 200</P><P>&nbsp;&nbsp;&nbsp; Laura, 300</P><P>&nbsp;&nbsp;&nbsp; Jim, 1000</P><P>&nbsp;&nbsp;&nbsp; Dan, 1000</P><P>&nbsp;&nbsp;&nbsp; Laura, 1000</P><P>];</P><P></P><P>Saludos.</P></BODY></HTML> Mon, 23 Apr 2018 10:39:03 GMT https://community.qlik.com/t5/QlikView/combining-2-table/m-p/78075#M778371 fvelascog72 2018-04-23T10:39:03Z Re: combining 2 table https://community.qlik.com/t5/QlikView/combining-2-table/m-p/78076#M778372 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Mon, 23 Apr 2018 10:41:33 GMT https://community.qlik.com/t5/QlikView/combining-2-table/m-p/78076#M778372 Anonymous 2018-04-23T10:41:33Z Re: combining 2 table https://community.qlik.com/t5/QlikView/combining-2-table/m-p/78077#M778373 <HTML><HEAD></HEAD><BODY><P>May be this?</P></BODY></HTML> Mon, 23 Apr 2018 10:44:57 GMT https://community.qlik.com/t5/QlikView/combining-2-table/m-p/78077#M778373 shiveshsingh 2018-04-23T10:44:57Z