Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
varunjain
Creator
Creator

problem in linking

Hi,

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  member ID is 789 , the column shoes it like 000789 and for 87 it is showing as 000087.

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.

Please assit.


BR-

VJ

2 Replies
tresesco
MVP
MVP

Use Num() to remove leading zeros.

Anonymous
Not applicable

the field with 0 use

text(num(yourIDwith000,'#0#')) to link with the other table where the ID is without 0