Example: Harmonizing County Data for UK Charging Sites
We have downloaded UK government data on electric vehicle charging sites, which we want to join to our sales data, aggregated by UK county.
|
Electric Vehicle Charging Entity County Column Value |
Geo Master Data County Name Column |
|---|---|
|
Argyll |
- |
|
Argyll & Bute |
- |
|
Argyll and Bute |
Argyll and Bute |
|
Step |
Result |
|---|---|
|
We create a view to:
|
|
|
We create an intelligent lookup, add our view as the input entity, and set the pairing column to County, as this is the column that contains the data that should be joined with our lookup entity. |
|
|
We add our Geo view as the lookup entity, and select the County ID and County Name columns as return columns. |
|
|
We create a fuzzy rule to compare county names in each entity. |
|
|
We deploy and run the intelligent lookup and our rule is able to match just under half the records. We review and process the remaining records in the Preview Data panel. |
|




