Link non matching data

[#1]

Hi everyone,

I am struggling to get two tables to connect properly. In both tables I have the connecting key "Trading postcode" but the problem is that in one of my data sets I am using the full post code etc. W3 BT6, whereas in my other table I am only using the outcode. In this example it would then be W3.

I would like QV to associate the data only using the outcode. So that everything up until a space would be compared and then associated. in this case everything from the first data set starting with W3 should be matched to the W3 in the other set. 

I have tried using a wildcard in different places but nothing seems to work.

Thanks in advance,

Andreas Parker

[#2]

Now everything works as it should in regards to connecting the tables.

Only problem is that it does not associate the postcode with the Outcodes.

when i write:

subfield([Trading postcode],' ',1) as mykey

the "1" should be the field number. Is the the number of the fields loaded in the ongoing statement? for example

Load

x,

y,

z

From

Example;

then z would be field no. 3 right?

[#3]

replace

subfield(Outcodes,' ',1) as mykey;

with

Outcodes as mykey

[#4]

It still does not seem like the postcodes and outcodes are matched.

subfield(Outcodes,' ',1) as mykey;

Am i right when I say that there is a space between the two ' '. This should be implemented into qlikview as well right?

Thanks a lot!. This works 99% and I am sure that I can get it to work shortly.

[#5]

It works! I had to manually add the space and everything was good.

Clever Anjos I need to give you a beer at some point. You saved my day as well as my inner peace throughout the weekend.

Ok to be serious. Thanks a lot, this was a relief.

Kind regards

Andreas Parker