DQC Logo
|

How to apply the address data improvement

The address data improvement workflow allows you to enrich/improve address data in a table. It uses an agentic approach to automatically improve data on countries, cities, streets, etc.

What does it solve?

For any table with address data, i.e., country data, city data, street data etc, respective coljumns will be validated and enriched or improved where necessary and possible.

This is what it looks like:

Workflow setup

There is a clear workflow that can be followed. Consider the following example:

1. Select file on DQC Platform (from a connector or static file)

2. Set up rules to identify incorrect address data (e.g., missing entries to enrich address data)

Set up a 'not empty' rule for the columns including address data

3. Go to “Issues" and click on “Improve data"

4. Set up workflow

Here, you can simply set up a workflow consisting of "Data input", "Address validation" and "Preview". Just select the nodes from the nodes library and add them via drag-and-drop.In the next step, the nodes can be specified.

5. Specify nodes

Data input node: By clicking on the pen icon, you can specify the node. Set a filter or exclude individual rows explicitly if needed.

Address validation node: Select the columns for which addresses should be enriched (based on the data quality rules defined):

  • Select all relevant address columns

  • Match the respective columns with the geo coder fields

  • Optionally, enrich the geo coder search with a web search

6. Prepare results

Two options to see results: Preview node or CSV download.

For the preview node: open the node and conduct a workflow test (if the file does not include too many entries). The survivor will be shown including a confidence score.

To get a CSV download with results, click on Run and then on the download button

undefined Notes

How to apply the address data improvement | DQC