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.