pbPassingBI
/
knime/flashcards/knime-cards-manipulate

Data manipulation — 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. Column Filter and Row Filter — what are the key points?

    Filter columns early — it reduces memory and speeds everything downstream · Row Splitter shows what was excluded; Row Filter discards it silently · Reference Row Filter is the IN / NOT IN equivalent Read the lesson

  2. The Rule Engine — what are the key points?

    Rules evaluate top to bottom; the first match wins · Order from most specific to least, and end with a TRUE catch-all · Rule Engine for conditions, Math Formula for arithmetic, String Manipulation for text Read the lesson

  3. Missing values — what are the key points?

    Missing is a distinct state, not an empty string or zero · Every fill strategy asserts something about the data — choose per column · Remove row across several columns can discard most of the table Read the lesson