topic Re: Left Join primary with 0 in the left in QlikView https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368918#M137147 <HTML><HEAD></HEAD><BODY><P>Sure, load the ID1 fields as text:</P><P></P><P>Text(ID1) as ID1</P><P></P><P>This will separate 60 and 060.</P></BODY></HTML> Thu, 26 Jul 2012 09:54:36 GMT Anonymous 2012-07-26T09:54:36Z Left Join primary with 0 in the left https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368915#M137144 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a problem with the left join</P><P></P><P><SPAN style="color: #333333; text-decoration: underline;">Example : </SPAN></P><P></P><P><STRONG>Table A</STRONG></P><P>ID1&nbsp; ART</P><P>60&nbsp;&nbsp; articleB</P><P>100 articleC</P><P>...</P><P></P><P><STRONG>Table B</STRONG></P><P>ID1&nbsp; LIBID1<STRONG><BR /></STRONG></P><P>060 TOTO</P><P>60&nbsp;&nbsp; TATA</P><P></P><P>When I use the left join, the program return 2 rows</P><P>LEFT JOIN (Table A)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Select ID1, LIBID from Table B</P><P></P><P><SPAN style="color: #ff0000;"><STRONG>60 articleB TOTO ????</STRONG></SPAN></P><P><STRONG>60 articleB TATA</STRONG></P><P></P><P>Could you help me please ?</P></BODY></HTML> Thu, 26 Jul 2012 09:36:32 GMT https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368915#M137144 2012-07-26T09:36:32Z Re: Left Join primary with 0 in the left https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368916#M137145 <HTML><HEAD></HEAD><BODY><P>060 will be interpreted as a numeric value (60) and joined accordingly unless you specify Text().</P></BODY></HTML> Thu, 26 Jul 2012 09:38:40 GMT https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368916#M137145 Anonymous 2012-07-26T09:38:40Z Re: Left Join primary with 0 in the left https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368917#M137146 <HTML><HEAD></HEAD><BODY><P>So there is no solution ?</P></BODY></HTML> Thu, 26 Jul 2012 09:47:44 GMT https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368917#M137146 2012-07-26T09:47:44Z Re: Left Join primary with 0 in the left https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368918#M137147 <HTML><HEAD></HEAD><BODY><P>Sure, load the ID1 fields as text:</P><P></P><P>Text(ID1) as ID1</P><P></P><P>This will separate 60 and 060.</P></BODY></HTML> Thu, 26 Jul 2012 09:54:36 GMT https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368918#M137147 Anonymous 2012-07-26T09:54:36Z Re: Left Join primary with 0 in the left https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368919#M137148 <HTML><HEAD></HEAD><BODY><P>The problem is not with the left join but when I import the data.</P><P></P><P>The table B is an access table, and the field ID1 is in Text exactly like that </P><P><STRONG>Table B</STRONG></P><P>ID1&nbsp; LIBID1<STRONG><BR /></STRONG></P><P>060 TOTO</P><P>60&nbsp;&nbsp; TATA</P><P></P><P>when I import the data into Qlikview</P><P></P><P>SQL SELECT ID1 FROM TableB</P><P></P><P>I have this result </P><P>ID1&nbsp; LIBID1<STRONG><BR /></STRONG></P><P>060 TOTO</P><P><STRONG>060</STRONG> TATA</P><P></P><P>The function Text(ID1) doesn't work with Access</P><P></P><P>Thank you for your help</P></BODY></HTML> Thu, 26 Jul 2012 12:37:28 GMT https://community.qlik.com/t5/QlikView/Left-Join-primary-with-0-in-the-left/m-p/368919#M137148 2012-07-26T12:37:28Z