Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
replace
subfield(Outcodes,' ',1) as mykey;
with
Outcodes as mykey
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.
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