Page Comparison

...

• add a new field called ISIN_country and populate this field by extracting the :

  • If primary_ISIN = ‘Unlisted’ or null, then ISIN_country = null

  • Else ISIN_Country = first two chars of

  the

  • primary_ISIN

  field

• add a new field called ISIN_countryISOAlpha2Code and populate this field by using countryISOAlpha2Code

  • If country = null, countryISOAlpha2Code = ISO code substitution on top of ISIN_country field (e.g. if ISIN_Country = ‘PR’, then countryISOAlpha2Code = ‘US’)

    • Please note that certain country codes will not exist - these are old country codes like CS or SU. If you can’t find a substitution, then countryISOAlpha2Code = null.

  • Else countryISOAlpha2Code = ISO code substition on top of country field (e.g. if ISIN_Country = ‘VG’, then countryISOAlpha2Code =

  ‘US’)

  • ‘GB’)

    • Please note that certain country codes will not exist - these are old country codes like CS or SU. If you can’t find a substitution, then countryISOAlpha2Code = null.

Match Input fields explanation:

• name → name

• country → countryISOAlpha2Code

  if country = null, use ISIN_

  countryISOAlpha2Code → countryISOAlpha2Code

• town_or_address → addressLocality

...