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: 
MichaelFL
Contributor III
Contributor III

Join fields with different length

Hello, i would like to join two field (materialno) .

The first loaded table has  values with 12345,23456 and the second table has 000000000000012345 or 000000000009012345

Table 1  5-digit

Table 2 18-digit.

How can I change it ?   Many thanks in advance.

1 Solution

Accepted Solutions
MichaelFL
Contributor III
Contributor III
Author

Thank you for fast answer. 

How to do this when the second table has also values with 8 digit?

View solution in original post

4 Replies
DavidM
Partner - Creator II
Partner - Creator II

If the identifier in the second field is always last five numbers you can do it like this:

 

Right(Field2,5) as Field2

 

Make sure that both fields have the same name when joining

MichaelFL
Contributor III
Contributor III
Author

Thank you for fast answer. 

How to do this when the second table has also values with 8 digit?

DavidM
Partner - Creator II
Partner - Creator II

If the identifier is always 5 digits it doesn't matter. The function always takes last 5 numbers

MichaelFL
Contributor III
Contributor III
Author

now I understand Thanks 🙂