Building flows — flashcards
One card per lesson — 3 in this module. Recall the key points, then check. 3 cards. Click a card to flip, or use the arrow keys and space bar.
The Prep interface — what are the key points?
The profile pane shows each field's value distribution as you work · Clicking a value highlights matching rows across every field · Prep builds on a sample; the full data is only processed on run Read the lesson
Input steps — what are the key points?
Uncheck unneeded fields at the input — everything downstream gets faster · A wildcard union reads a whole folder of matching files at once · Input-level filters are the cheapest, since rows never enter the flow Read the lesson
Join and Union steps — what are the key points?
The join summary shows matched and unmatched counts before you commit · A row count higher than the left input means a fan-out · Union matches by field name and flags mismatches for manual merging Read the lesson