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.

TIBCO recommends that you 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 Automatic 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.