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: 
Not applicable

Link fields based on first 6 digits

Hi I am new to QlikView so please bear with me.

I have a couple of SQL tables with totally different field names, the data in the two fields kind of links.

The first field contains a 16 digit number, the second field contains only the first 6 digits of that same number.

e.g:

Field 1
12345678910112
56521245556232
44444554112255
7885533256+6+3

Field 2
123456
565212
444445
788553

How would I go about linking these 2 fields?

thanks in advance

1 Solution

Accepted Solutions
israrkhan
Specialist II
Specialist II

hi try like below:

Table1:

load Field1

from table1;

Table2:

load Field2 as field3, left(Field2, 6) as Field2

from table2,

it will only get the first 6 digit of field2, as a new field Field2,

then it will automatically link the two table,

hope it helps..

View solution in original post

2 Replies
israrkhan
Specialist II
Specialist II

hi try like below:

Table1:

load Field1

from table1;

Table2:

load Field2 as field3, left(Field2, 6) as Field2

from table2,

it will only get the first 6 digit of field2, as a new field Field2,

then it will automatically link the two table,

hope it helps..

Not applicable
Author

That's great, works a treat.

Many thanks your your help!