Congruence

Created by Dariusz Szczendzina, Modified on Wed, 12 Jul, 2023 at 10:44 AM by Dariusz Szczendzina

Congruence analyses two data field values to examine if they are aligned.


Country

Check if a country aligns with an email address, telephone number or a URL. E.g.

Country to Email

Input a country with an email and identify whether they align.

EmailCountryCodeDetails
example@microsoft.co.ukGB1TRUE
example@microsoft.usGB0FALSE
example@microsoft.orgGB2Unknown

Country to Phone

Input a country with a telephone number and identify whether they align. E.g.

EmailCountryCodeDetails
44751 1111 111GB1TRUE
11111 1111 111GB0FALSE
47511 1111 111GB0FALSE

Country to URL

Input a country with a URL and identify whether they align. E.g.

URLCountryCodeDetails
google.co.ukGB1TRUE
google.comGB2Unknown
google.co.ukUS0FALSE

Email

Input a given name and family name to identify whether both or either match up with a given email. E.g.

Input

EmailGiven NameFamily Name
john.smith@example.comJohnSmith
jane.smith@example.comJohnSmith
john.shmidt@example.comJohnSmith
jane.shmidt@example.comJohnSmith
example@example.comJohnSmith

Output

Output (Code)Output (Details)
14Given Name and Family Name both found in email
11Given Name Initial and Family Name both found in email
12Given Name and Family Name Initial both found in email
5Given Name Initial and Family Name Initial both found in email
0No Name congruence with email

Salutation

Check if a salutation aligns with a name in a given language. E.g.

SalutationGiven NameCodeDetails
MrMartin1TRUE
MrsMary1TRUE
MrMary0FALSE
MrsMartin0FALSE

Custom Functions

DQ.CONGRUENCE_EMAIL

The DQ.CONGRUENCE_EMAIL function checks if email is congruent with name.

Parameters:

email (string), email to be checked for congruence

firstName (string), first name to be found

lastName (string), last name to be found

spillDown (boolean), if true results will spill down instead of right

returns (string[][]), returns spill of status code, details

DQ.CONGRUENCE_COUNTRY

The DQ.CONGRUENCE_COUNTRY function checks if input is congruent with country.

Parameters:

string (string), input to be checked for congruence, in form of: email, phone, URL

country (string), country identifier, preferred format is ISO2, otherwise the service will attempt to derive country from the input

action (string), type of congruency to check for, from list:

  • CountryToEmail
  • CountryToPhone
  • CountryToURL

returns (string[][]), returns spill of status code, details

DQ.CONGRUENCE_SALUTATION

The DQ.CONGRUENCE_SALUTATION function checks if salutation is congruent with first name.

Parameters:

salutation (string), salutation to be checked for

givenName (string), given name to be checked for, used to derive gender

language (string), language of input, from list:

  • English
  • Spanish
  • French
  • Italian
  • German

spillDown (boolean), if true results will spill down instead of right

returns (string[][]), returns spill of status code, details

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article