How can you configure the CSV Reader node in KNIME to load a CSV file and optionally modify the table structure during loading?
Configure the CSV Reader node by double-clicking it or clicking the cog icon to open its configuration window, then click Browse to choose the CSV file. The node previews the table, and you can adjust reading settings such as column delimiters. For optional table changes during loading, open the Transformation tab to rename columns, remove some, or reorder them.
In KNIME, after dragging the CSV Reader node onto the canvas, it shows a red traffic light because it is not yet configured. Double-click the node or click the cog icon that appears when the node is selected to open its configuration window. The most important step is clicking Browse in the upper-right area and selecting the CSV file you want to load. The node then recognizes the file structure and shows a table preview at the bottom. You can manually edit reading settings, such as column delimiters, using the parameters in the middle of the configuration page. If you want to modify the table structure while loading, click the Transformation tab at the top. There you can rename columns, remove some columns, and change their order, without needing separate Column Renamer, Column Filter, or Column Resorter nodes afterward. After making your choices, click OK, optionally add a meaningful annotation under the node, and execute it by right-clicking and selecting Execute, pressing F7, or clicking the play icon.
Key points
- Double-click the CSV Reader node or click its cog icon to open the configuration window.
- Click Browse to select the CSV file; the node provides a preview of the table.
- Use the parameters in the middle of the window to adjust reading settings such as column delimiters.
- The Transformation tab lets you rename columns, remove columns, and reorder columns during loading.
- Close the configuration with OK, then execute the node and confirm the green status light.
AI Agents and Applications
Andrea De Mauro
MEAP Edition Version 7 · Manning Publications