Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
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..
That's great, works a treat.
Many thanks your your help!