pbPassingBI
/
alteryx/flashcards/alteryx-cards-prep

Cleaning & preparation — 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.

  1. The Select tool — what are the key points?

    Deselect unneeded fields early — everything downstream gets faster · Reducing a string size truncates silently · Use Fixed Decimal for money, never Double Read the lesson

  2. The Formula tool — what are the key points?

    One Formula tool can hold several expressions, evaluated in order · Arithmetic involving null yields null — guard with IsNull · Multi-Field Formula applies one expression across many fields Read the lesson

  3. Filter and Data Cleansing — what are the key points?

    Filter splits into True and False outputs — inspect both · Data Cleansing handles nulls, whitespace and case across many fields at once · Clean text keys before joining, or matches fail silently Read the lesson