topic Re: Link fields based on first 6 digits in QlikView

Link fields based on first 6 digits

Tue, 22 Oct 2013 08:41:34 GMT

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:

How would I go about linking these 2 fields?

thanks in advance

israrkhan — Tue, 22 Oct 2013 09:07:00 GMT

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

Tue, 22 Oct 2013 09:46:29 GMT

That's great, works a treat.

Many thanks your your help!