Running Address Cleansing

Run address cleansing on your data to identify and correct errors or inconsistencies.

Note: TIBCO GeoAnalytics Builder only supports its country name, so if your data has the country information, ensure that you set your country column type to Country before running address cleansing.

It is good practice to validate your data before running address cleansing.

Procedure

  1. On the project page, click .
  2. In the Login dialog, enter the user name and key to connect to GeoAnalytics.
    Note: This step is required only when you are using the enterprise edition.
  3. Specify the number of matched results for each address to be returned:
    • Pick the best result: Only one best result is returned.
    • Take the best n results for each address: The specified number of best results are returned.
  4. Move the percentage slider to specify the similarity threshold.
  5. In the Map column area, map the source columns to the destination columns:
    • Automatic mapping: Click Auto map. Sometimes, automatic mapping is not able to match all columns.
    • Manual mapping: Drag the source and destination columns to the mapping area manually.
    Note: If you do not map the country column in the mapping area, then US is used as the default country.
  6. Click Run to launch the address cleansing operation.
Contents
Search Results