topic Re: problem in linking in QlikView https://community.qlik.com/t5/QlikView/problem-in-linking/m-p/632427#M1091724 <HTML><HEAD></HEAD><BODY><P>the field with 0 use</P><P>text(num(yourIDwith000,'#0#')) to link with the other table where the ID is without 0</P></BODY></HTML> Wed, 14 May 2014 06:45:34 GMT Anonymous 2014-05-14T06:45:34Z problem in linking https://community.qlik.com/t5/QlikView/problem-in-linking/m-p/632425#M1091722 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a SAP table with a Key column lets say Member ID with number values but with Zeros appended in the front. All the values in member ID are of length 6 so if the&nbsp; member ID is 789 , the column shoes it like 000789 and for 87 it is showing as 000087.</P><P>i want to link this table with another table which has member ID but the values there dont have appended Zeros so the member ID woul read like 789 and 87. i am facing diffciulty in linking them. I think there would a string fuction to do the same but I m not able to find a solution for the same.</P><P>Please assit.</P><P><BR />BR-</P><P>VJ</P></BODY></HTML> Wed, 14 May 2014 06:40:36 GMT https://community.qlik.com/t5/QlikView/problem-in-linking/m-p/632425#M1091722 varunjain 2014-05-14T06:40:36Z Re: problem in linking https://community.qlik.com/t5/QlikView/problem-in-linking/m-p/632426#M1091723 <HTML><HEAD></HEAD><BODY><P>Use Num() to remove leading zeros.</P></BODY></HTML> Wed, 14 May 2014 06:42:31 GMT https://community.qlik.com/t5/QlikView/problem-in-linking/m-p/632426#M1091723 tresB 2014-05-14T06:42:31Z Re: problem in linking https://community.qlik.com/t5/QlikView/problem-in-linking/m-p/632427#M1091724 <HTML><HEAD></HEAD><BODY><P>the field with 0 use</P><P>text(num(yourIDwith000,'#0#')) to link with the other table where the ID is without 0</P></BODY></HTML> Wed, 14 May 2014 06:45:34 GMT https://community.qlik.com/t5/QlikView/problem-in-linking/m-p/632427#M1091724 Anonymous 2014-05-14T06:45:34Z