Environment & data — quiz

How do you see the data mid-workflow?

1. Run and export
2. Click the connection between two tools
3. Open the source file
4. Add a Browse tool only

Answer: Click the connection between two tools — Any connection shows a preview and record count.

Which is the most important thing to check after a Join?

1. Field order
2. The record count
3. Colours
4. Tool position

Answer: The record count — A changed record count is the usual sign of a fan-out or lost rows.

Your workflow duplicated all its data on the second run. Cause?

1. A Join issue
2. Output set to Append to existing
3. Wrong delimiter
4. A Browse tool

Answer: Output set to Append to existing — Use delete-and-append or overwrite when reruns are possible.

To read twelve monthly CSVs with the same structure:

1. Twelve Input tools
2. A wildcard in the file path
3. A Union of Excel sheets
4. The Append Fields tool

Answer: A wildcard in the file path — Output File Name as Field then records the source file.