topic Re: Linking tables in QlikView https://community.qlik.com/t5/QlikView/Linking-tables/m-p/1122773#M631292 <HTML><HEAD></HEAD><BODY><P>Looks like you want to treat Asset Code as text field - see attached</P></BODY></HTML> Mon, 27 Jun 2016 15:43:34 GMT Digvijay_Singh 2016-06-27T15:43:34Z Linking tables https://community.qlik.com/t5/QlikView/Linking-tables/m-p/1122772#M631291 <HTML><HEAD></HEAD><BODY><P>I am trying&nbsp; to create a report using data from two different tables and linking them by using an 8 digit number asset</P><P></P><P>Unfortunately this 8 digit number is not a sequential system generated but manually entered and I have a number of data lines which are same number but not prefixed to make up 8 digit. Because of this they are not linking properly can anyone help with a solution.</P><P></P><P>Table 1</P><P></P><P><STRONG>Asset Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Asset Desc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Asset Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG></P><P>00022500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BMW&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10,000</P><P>22500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SAAB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000</P><P></P><P>Table 2</P><P></P><P><STRONG>Asset Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Asset Life&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Asset Location</STRONG></P><P>00022500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; London</P><P>22500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Swansea</P></BODY></HTML> Mon, 27 Jun 2016 15:32:34 GMT https://community.qlik.com/t5/QlikView/Linking-tables/m-p/1122772#M631291 Anonymous 2016-06-27T15:32:34Z Re: Linking tables https://community.qlik.com/t5/QlikView/Linking-tables/m-p/1122773#M631292 <HTML><HEAD></HEAD><BODY><P>Looks like you want to treat Asset Code as text field - see attached</P></BODY></HTML> Mon, 27 Jun 2016 15:43:34 GMT https://community.qlik.com/t5/QlikView/Linking-tables/m-p/1122773#M631292 Digvijay_Singh 2016-06-27T15:43:34Z Re: Linking tables https://community.qlik.com/t5/QlikView/Linking-tables/m-p/1122774#M631293 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Maybe you can use Num([Asset Code],'00000000') in your load script to force 8 digits with leading zero.</P></BODY></HTML> Mon, 27 Jun 2016 15:58:14 GMT https://community.qlik.com/t5/QlikView/Linking-tables/m-p/1122774#M631293 Anonymous 2016-06-27T15:58:14Z