Reltio Connect

 View Only
  • 1.  Loqate validation - validity of postal code against the country

    Posted 12-05-2023 04:54

    Hi, in the customer database that we need Loqate validations for there are often incorrect combinations between country & zip code. 

    Let's say the expected postal code patterns are a combination of numbers and letters with a space in between (N - number, L - letter):

    LLNL NLL
    NLN LNN
    NL LNN
    NLL LNN
    NNL LNN
    NNLL LNN

    Is Loqate able to recognize the given combination is incorrect? 

    Similarly, if the country code & county combination in the database is incorrect, can this be recognized by Loqate?



    ------------------------------
    Maria Glosnicka
    GEHC
    ------------------------------


  • 2.  RE: Loqate validation - validity of postal code against the country

    Reltio Employee
    Posted 12-06-2023 14:02

    Maria,

    Thank you for your questions.

    Yes, assuming the country and other address data is accurately provided, the Loqate engine will be able to determine that the postal code that was provided does not conform to the accepted format of the country/region and will typically return  a corrected value in its response. There are limits to the engine's ability to do this, however, since it is contingent upon finding a matching reference address. For instance, if there are several other errors in the address input, it is possible that the engine might make some unexpected assumptions when attempting to parse, analyze, and respond to what's been provided.

    To demonstrate, imagine a case where an address line is sent for verification and it contains details that perfectly match the street address of a location in one country, but it also contains reference to a locality from another country, and the country code of yet another country. The question becomes: How should the engine determine/choose which country's postal code format validate against? The algorithm is well-trained and often chooses correctly, but it is not infallible if the data quality at the source is very poor (typical garbage-in, garbage-out scenario).

    It's a deceptively simple question with a fairly complex answer, so I hope the above was useful. If I can help provide more detail on any of the above, please let me know.



    ------------------------------
    Best regards,

    Jack Hain
    Senior Product Manager
    Reltio, Inc.
    ------------------------------