Handle Text Values

Confirm that text values in a column are uniform in formatting, spelling, and language. Inconsistencies can occur within data sources and after merging data from multiple data sources.

To ensure that your data is grouped properly during analysis, standardize the text strings used for dimensions.

• Use the Bucket transformation to replace similar values with a consistent value. For example, replace abbreviations with full text strings, or replace text strings with abbreviations.
• Fix other spelling inconsistencies, such as typographical errors, plurals, uppercase and lowercase characters, and so on.
• Use a column profile in CRM Analytics to review string length. For example, some column values require the same length, such as a 5-digit zip code or 10-digit phone number.