topic Partial Data matching in QlikView https://community.qlik.com/t5/QlikView/Partial-Data-matching/m-p/260229#M1206461 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have two tables, one with customer information and their full postal code (canada) and another with the first three letters of postal codes and a territory code (ex A1, A2, A3....)</P><P>Does anybody know how I would go ahead with linking customers and their postal codes (which are 6 digits) to their respective territories?</P><P></P><P></P><P></P></BODY></HTML> Tue, 01 Jun 2010 18:30:33 GMT 2010-06-01T18:30:33Z Partial Data matching https://community.qlik.com/t5/QlikView/Partial-Data-matching/m-p/260229#M1206461 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have two tables, one with customer information and their full postal code (canada) and another with the first three letters of postal codes and a territory code (ex A1, A2, A3....)</P><P>Does anybody know how I would go ahead with linking customers and their postal codes (which are 6 digits) to their respective territories?</P><P></P><P></P><P></P></BODY></HTML> Tue, 01 Jun 2010 18:30:33 GMT https://community.qlik.com/t5/QlikView/Partial-Data-matching/m-p/260229#M1206461 2010-06-01T18:30:33Z Partial Data matching https://community.qlik.com/t5/QlikView/Partial-Data-matching/m-p/260230#M1206463 <HTML><HEAD></HEAD><BODY><P>Create a new field where you just use the first three letters of the postal code</P><P>Left([Postal Code],3) as [Postal Link]</P><P>Then simply give it the same name as the field with the first 3 letters of the postal code in your second table. Done!</P></BODY></HTML> Tue, 01 Jun 2010 20:13:46 GMT https://community.qlik.com/t5/QlikView/Partial-Data-matching/m-p/260230#M1206463 2010-06-01T20:13:46Z