5 Replies Latest reply: Nov 13, 2015 5:07 AM by Declan Bermingham RSS

    Consistency check for postal code & city

    Giacinto Abbruzzese

      Hello,

       

      my database consists of two Excel-files:

       

      1. Official data on postal codes and corredponding cities

      2. Internal system data which needs to be validated

       

      I want to run a loop which checks the internal system data file (2.) for inconsistencies in the combination of postal code and cityname with the help of the official data file (1.) on postal codes and corresponding cities.

       

      So far i've loaded both excel-files into my qlik-sense-app. How would the script structure look like to realise the consistency checks mentioned above?

       

      Thank you in advance and happy qliking!

       

      official_plz.JPGinternal system_plz.JPG

       

      Nachricht geändert durch Giacinto Abbruzzese