Workflow & automation — quiz

How do you test a workflow without running one branch?

1. Delete the tools
2. Disable the container holding them
3. Add a Filter
4. Comment them out

Answer: Disable the container holding them — Disabling skips everything inside on the next run.

A good tool annotation says:

1. The tool name
2. Why the tool is there
3. The record count
4. The author

Answer: Why the tool is there — What it is, is already visible on the canvas.

A field holds "widget, bolt, nut" and you need one row each. Use:

1. RegEx Match
2. Text to Columns, split to rows
3. Cross Tab
4. Append Fields

Answer: Text to Columns, split to rows — Splitting to rows is the option people overlook.

Why specify the input format in the DateTime tool?

1. Speed
2. Ambiguous formats are misparsed silently
3. It is required
4. To handle nulls

Answer: Ambiguous formats are misparsed silently — 03/04/2024 could be March or April.

To produce one CSV per region in a single run:

1. One workflow per region
2. Take File/Table Name From Field on the Output tool
3. A Union tool
4. A container per region

Answer: Take File/Table Name From Field on the Output tool — The field value becomes the file name.

Which makes a workflow safe to rerun?

1. Append outputs
2. Relative paths and overwrite or delete-and-append outputs
3. More containers
4. Disabling Browse tools

Answer: Relative paths and overwrite or delete-and-append outputs — Append plus absolute paths is the usual handover failure.