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 that are used to connect to Maporama, 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. ResultTwo 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.