User Tools

Site Tools


congruence

Congruence

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.

Email Country Code Details
example@microsoft.co.uk GB 1 TRUE
example@microsoft.us GB 0 FALSE
example@microsoft.org GB 2 Unknown

Country to Phone

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

Phone Country Code Details
44751 1111 111 GB 1 TRUE
11111 1111 111 GB 0 FALSE
47511 1111 111 GB 0 FALSE

Country to URL

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

URL Country Code Details
google.co.uk GB 1 TRUE
google.com GB 2 Unknown
google.co.uk US 0 FALSE

Email

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

Input

Email Given Name Family Name
john.smith@example.com John Smith
jane.smith@example.com John Smith
john.shmidt@example.com John Smith
jane.shmidt@example.com John Smith
example@example.com John Smith

Output

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

Salutation

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

Salutation Given Name Code Details
Mr Martin 1 TRUE
Mrs Mary 1 TRUE
Mr Mary 0 FALSE
Mrs Martin 0 FALSE

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

congruence.txt · Last modified: 2023/09/19 12:10 by qpww5

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki