pbPassingBI
/

Workflow & automation — 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. Organising workflows — what are the key points?

    Containers collapse a large workflow into readable stages · Disable a container to skip that branch while testing · Annotate why a tool exists, not what it is Read the lesson

  2. Parsing tools — what are the key points?

    Text to Columns can split to rows, not just columns · RegEx Parse with capture groups splits a field into clean columns · Specify the incoming date format — guessing fails silently Read the lesson

  3. Outputs and running workflows — what are the key points?

    Take File/Table Name From Field writes one file per group · Write rejected rows to an exceptions output rather than dropping them · Use relative paths and non-appending outputs so reruns are safe Read the lesson