For more information, please refer to this announcement explaining best practices for getting answers to questions.
Geography Hierarchy HDL is failing
Summary:
Geography Hierarchy HDL is failing to load the data
Content (required):
Error details:
The values {ATTR_VALUES} aren't valid for the attribute {ATTR_NAME}.
The values AVON,United Kingdom,COUNTY aren't valid for the attribute GeographyId.
The values SURREY,United Kingdom,COUNTY aren't valid for the attribute GeographyId.
Version (include the version you are using, if applicable):
21 D
Code Snippet (add any code snippets that support your topic, if applicable):
Below is the HDL file saved as GeographyHierarchy.dat
METADATA|GeographyHierarchyNode|Name|HierarchyId|CountryCode|Level1|Level2|DeleteFlag
MERGE|GeographyHierarchyNode|JPMC-Posting-Location-Hierarchy-Apr062022||GB|AVON||
MERGE|GeographyHierarchyNode|JPMC-Posting-Location-Hierarchy-Apr062022||GB|SURREY||