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.
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
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
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