Match keys that are similar rather than identical (e.g., matching "Connecticut" and "Conecticut").
Aggregate data to create summaries, charts, or pivot tables. Monarch
Use the Combine button in the Prepare window to join disparate data sources (like left/right outer, inner joins). Match keys that are similar rather than identical (e