Lookup error for country name.

Problem : 

The RDM lookup is not resolving the country name when the same country is contributed by two different sources.

For example, in the screenshot below, the country : Antigua and Barbuda is not resolved by all the provided crosswalk values.

• There is a lookup error as well : 

{ 
                            "type": "configuration/entityTypes/Organization/attributes/Addresses/attributes/Country", 
                            "ov": false, 
                            "value": "Antigua And Barbuda", 
                            "lookupError": "1003: RDM canonical value mapping not found for value [Antigua And Barbuda] and source [ReltioCleanser] in tenant [Tenant_ID]", 
                            "uri": "entities/51j69RA/attributes/Addresses/cOFm9hzk/Country/JgZNosr" 
                        } 
                    ],

Cause : 

The problem arises due to the case sensitivity inherent in the RDM lookup. This means that when the system attempts to retrieve information, it distinguishes between uppercase and lowercase letters, which can lead to mismatches or failures if the cases do not align exactly. As a result, even minor differences in letter casing can cause the lookup to fail, leading to errors or unexpected behavior in the application.

Solution : 

To resolve this issue, please add the country name with the letter 'A' in uppercase — Antigua And Barbuda to the RDM lookup and ensure it is mapped to the appropriate source.
 

Antigua And Barbuda