Cleansing Address

Use the address cleansing function to check the address data.

Procedure

  1. On the toolbar, click Address.
  2. In the "TIBCO GeoAnalytics configuration" dialog, enter your user name and key to access the Majorana service, and then click Save.
    Note: This step is required only when you are using the enterprise edition.
  3. On the "Address cleansing" page, move the slider to change the similarity threshold to 80%.
  4. Drag the State and City columns from the Source Columns area to the middle area.
  5. Drag the State and City columns from the Destination Columns area to the middle area.
  6. Click Run to start checking.

Result

Two columns, addr_city and addr_state are added, displaying the automatically cleansed address. You can delete the original City and State columns.