Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
MichaelFL
Contributor II
Contributor II

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 II
Contributor II
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
Partner

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 II
Contributor II
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

DavidM
Partner
Partner

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

MichaelFL
Contributor II
Contributor II
Author

now I understand Thanks 🙂