You can review mismatch issues between data and match results in map layers, such as when there are ambiguous or partial matches between words.
If ambiguous results are present, consider adding more columns to the map visualization to get the specific match. For example, your map might have layers for City, Country, and Continent. You can also exclude rows of data.
- Create or open a project that contains map data with one or more data layers in a map visualization.
- Click the Visualization tab.
- Right-click the map visualization and select Location Matches from the menu to display the Location Matches dialog.
- Select a tab representing a map layer in the current
visualization to inspect how well your data matches the map
For example, select the Country tab to see how well your data matches with the Country map layer.
- Optionally click Map Layer to select a different layer or click Manage Map Layers to display the Console page.
- To review and resolve data mismatches use the columns:
The summary section above the table displays the number of locations and any issues.
Column Name Column Description Your Data Displays comma-separated geographical data. Match Indicates what matches with the map layer information. A match can be anything from No Match, Partial Match, to a 100% match. Matches are displayed initially sorted top down from the worst to the best matches.
- No Match - Displays a red warning triangle indicator.
- A Match with an issue - Displays
a yellow warning triangle indicator.
The warning doesn't indicate a poor match but an imperfect match for which you might want to review the use case.
- A Perfect Match - Displays no warning triangle indicator.
If you are matching Latitude and Longitude, the match values are Valid or Invalid.
Match Quality Quantifies how similar your mismatched strings are:
- No Match
- Number of Matches
- Percentage Confidence
Exclude Enables you to exclude entire rows of data.
- Click the filter icon in the Match
column title and select a filter option.
The selected filter option determines what is displayed in the matches table.
Filter Option Description All Data Displays all types of matches. Good Matches Displays only 100% perfect matches. All Issues Displays partial matches, multiple matches and no match. Partial Matches Indicates the percentage difference between the strings being matched, and the number of additions, substitutions, or removals of characters needed to change one word to match another word. For example:
- Part of a string is exactly right,
- Most of a word is exactly right,
Multiple Matches Indicates how many matches exist for ambiguous cases.
For example, you may see
Barcelona, Spainmatching with
Barcelona Argentina. In this case you might want to revisit the data to add more detail to your GEO columns to ensure that you only match the correct columns.
No Match Indicates that there's no match.
- Part of a string is exactly right, such as
- Click in the Exclude column for each row of data that you want to exclude.
- Click the Exclude menu:
- Click Select All or Deselect All.
- Click one of Project Scope, Canvas Scope, or Visual Scope.
- Optionally add in more columns to the Category (Location) edge on the visualization to make your match more specific. For example, add Country data to remove a mismatch like Barcelona, Spain versus Barcelona, Argentina.
- Display the Location Matches dialog to check the summary for any remaining mismatches, and click OK when you are satisfied, or repeat previous steps as required.