Cleansing Address
Use the address cleansing function to check the address data.
Procedure
-
On the toolbar, click
Address.
-
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.
-
On the "Address cleansing" page, move the slider to change the similarity threshold to
80%.
-
Drag the State and City columns from the
Source Columns area to the middle area.
-
Drag the State and City columns from the
Destination Columns area to the middle area.
-
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.
Copyright © Cloud Software Group, Inc. All rights reserved.