Node-based fundamentals — quiz

What does a black triangle port carry?

1. A database connection
2. A data table
3. A model
4. A flow variable

Answer: A data table — The standard data table port.

The quickest way to inspect a node's output during development:

1. Export to CSV
2. The Node Monitor view
3. Re-run the workflow
4. The console

Answer: The Node Monitor view — It shows the selected node's output without opening a window.

A previously working node has turned red. Most likely cause?

1. KNIME crashed
2. An upstream column was renamed or removed
3. Out of memory
4. The file moved

Answer: An upstream column was renamed or removed — Hover for the specific message.

Changing a node's configuration:

1. Only affects that node
2. Resets it and everything downstream
3. Re-runs the workflow
4. Has no effect until saved

Answer: Resets it and everything downstream — Downstream inputs may now differ, so they must re-run.

Postcodes lose their leading zeros. Fix:

1. Change the delimiter
2. Set the column type to String in the reader
3. Use Excel Reader
4. Increase memory

Answer: Set the column type to String in the reader — Type guessing reads it as a number.

To read a folder of monthly CSVs in one node:

1. One reader per file
2. Point the reader at the folder with a *.csv filter
3. Use Concatenate only
4. Use the Joiner

Answer: Point the reader at the folder with a *.csv filter — Add a path column to record the source file.