Link fields based on first 6 digits

[#1]

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

[israrkhan · Accepted solution]

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

[#3]

That's great, works a treat.

Many thanks your your help!