13 Replies Latest reply: Nov 1, 2013 2:16 PM by Andreas Parker RSS

    Link non matching data

      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