Blending & structuring — flashcards
One card per lesson — 4 in this module. Recall the key points, then check. 4 cards. Click a card to flip, or use the arrow keys and space bar.
The Join tool — what are the key points?
The three anchors give unmatched-left, matched and unmatched-right at once · L + J should equal the original left record count · Summarize the right input first to prevent a fan-out Read the lesson
Union and Append Fields — what are the key points?
Union by name is safe; by position silently misaligns columns · Append Fields produces a Cartesian product — one source row, or it multiplies · Union stacks, Join matches, Append attaches to everything Read the lesson
Cross Tab and Transpose — what are the key points?
Transpose unpivots wide to long; Cross Tab pivots long to wide · Cross Tab builds column names from data — they change when the data does · Cross Tab sorts columns alphabetically, not chronologically Read the lesson
The Summarize tool — what are the key points?
Fields neither grouped nor aggregated are silently dropped · Summarize by the join key first to prevent a fan-out · Multi-Row Formula is the window-function equivalent, and needs a Sort first Read the lesson