...
View file | ||
---|---|---|
|
ISO Code Substitutions:
View file | ||
---|---|---|
|
For Match Logic, please see the latest file on:
Trello card | ||
---|---|---|
|
To match the data,
add a new field called ISIN_country and populate this field by extracting the first two chars of the primary_ISIN field
ISO Code Substitutions:
...
add a new field called ISIN_countryISOAlpha2Code and populate this field by using ISO code substitution on top of ISIN_country (e.g. if ISIN_Country = ‘PR’, then ISIN_countryISOAlpha2Code = ‘US’)
Match Input fields explanation:
name → name
country → countryISOAlpha2Code
if country = null, use ISIN_countryISOAlpha2Code → countryISOAlpha2Code
town_or_address → addressLocality
Acceptance rules (to be confirmed with D&B)
Accept all confidence code >=7
If ConfidenceCode <7, accept matches where matchGrade has the following pattern A*
Apply '1' AcceptanceIndicator to all above conditions