Use the Combine button in the Prepare window to join disparate data sources (like left/right outer, inner joins).
Here are the key steps to prepare data/features in Altair Monarch: Key Data Prep Steps in Altair Monarch
Match keys that are similar rather than identical (e.g., matching "Connecticut" and "Conecticut").
Use over 80 pre-built functions to clean and reshape data (e.g., splitting columns, filtering, changing data types).
Create traps to tell Monarch how to identify data in reports.
Create complex filters using expressions.
Aggregate data to create summaries, charts, or pivot tables.