Check the address postal

Black_Hole — Tue, 28 May 2019 10:41:09 GMT

Hello all,

I would like to check the quality of the postal address in my database.

I extract two tables: the first table concern all the postal address of my customer and the second table is the reference table.

In my customer table, the postal address can be true but not exactly equal to the postal address in my reference table.

For example the abbreviations in postal address from the users don't mean that the postal address is false.

Please could you share with me an easy way to match the two tables and to identify the postal address which doesn't match at all with the reference table.

Thank you in advance for your help.

topic Check the address postal in QlikView

Check the address postal