Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Linking tables

I am trying  to create a report using data from two different tables and linking them by using an 8 digit number asset

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.

Table 1

Asset Code         Asset Desc          Asset Value       

00022500             BMW                     10,000

22500                    SAAB                     5,000

Table 2

Asset Code         Asset Life            Asset Location

00022500             5 years                  London

22500                    2 years                  Swansea

1 Solution

Accepted Solutions
Digvijay_Singh

Looks like you want to treat Asset Code as text field - see attached

View solution in original post

2 Replies
Digvijay_Singh

Looks like you want to treat Asset Code as text field - see attached

Anonymous
Not applicable
Author

Hi,

Maybe you can use Num([Asset Code],'00000000') in your load script to force 8 digits with leading zero.