Showing results for 
Search instead for 
Did you mean: 

US/Global Address cleanse with only city and postal code

0 Kudos


I am currently trying to standardize two fields. One contains ship to locations and the other had postal code information. The data contains both US and International addresses and this table does not contain a street name or address.

Currently I am using US address cleanse and decode statements to divide up the records into either US or Global addresses (some records contain the country along with the city), however has anyone faced such a requirement and what was the best course they took? My main idea is to divide up the US and the Global addresses and then run them through either the US transform or the Global address transform.

Would it be better to put the ship to and zip-code into multi-line fields? Are there also any option settings that can be enabled in either transform to improve accuracy? Any advice would be appreciated.

Thank you

Accepted Solutions (0)

Answers (0)