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