Table of Contents
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.
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 |
Input a given name and family name to identify whether both or either match up with a given email. E.g.
Input
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