Qlik Community

Ask a Question

Qlik Sense Data Connectivity

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

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Contributor II
Contributor II

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

Contributor II
Contributor II

Thank you for fast answer. 

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

View solution in original post

Partner
Partner

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

Contributor II
Contributor II

now I understand Thanks 🙂