use R to read and write custom CSV files and read them back with different nodes

Read further about KNIME and CSV files:

CSV Reader (Labs)
https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.io.filehandling.csv.reader.CSVTableReaderNodeFactory
=> you can use the "Autodetect" function
=> you can import multiple CSV files with the same structure at once

Demonstrates how to import several CSV files with the new CSV reader from sub folders at once
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_csv_import_multiple_csv_types?u=mlauber71

Force all columns to be read as strings (use KNIME nodes only)
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_csv_import_force_all_string_pure_knime?u=mlauber71

use R library(readr) to read (messy) CSV file into KNIME
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_r_read_single_csv_file?u=mlauber71

KNIME Nodes for Wide Data (many columns)
https://hub.knime.com/knime/extensions/org.knime.features.base.widedata/latest

External resources

• HUB: use R to read and write custom CSV files and read them back with different nodes
• Demonstrates how to import several CSV files with the new CSV reader from sub folders at once
• R - Reads a file in table format and creates a data frame from it, with cases corresponding to lines and variables to fields in the file
• Force R’s readr to import all columns of a messy CSV file as strings - allow changing table structures
• use R library(readr) to read (messy) CSV file into KNIME