This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementCSV ReaderReads CSV files. Use this node if the workflow is used in a server or batch environment and the input files structure change between different invocations. In particular, this includes a variable number of input columns. Upon executing the node will scan the input file to determine number and types of the columns and output a table with the auto-guessed structure.
Note: If you are only using the desktop version of KNIME and your workflow is not meant to be used in a batch or server environment use the File Reader node. The file reader node has more configuration options and guesses meaningful default settings as it scans the input file during node configuration (in the dialog).
Options
CSV Reader
Limit Rows
CSV Reader Encoding
Popular Predecessors
Merge Variables6 %Excel Writer (XLS)5 %- Group Loop Start3 %
Generic Loop Start3 %Table Writer2 %Row Filter (deprecated)2 %- Create Temp Dir (legacy)2 %
Table Row to Variable2 %- External Tool2 %
- Google Cloud Storage File Picker (legacy)2 %
- String Configuration2 %
- Azure Blob Store File Picker (legacy)2 %
- File Chooser (legacy)1 %
- Integer Input (legacy)1 %
Column Rename1 %- String Widget1 %
Container Input (Variable)1 %Table Row To Variable Loop Start1 %- Table Creator1 %
- Java Snippet1 %
- Column List Loop Start1 %
- Try (Data Ports)< 1 %
- CSV Writer< 1 %
File Upload (legacy)< 1 %- Catch Errors (Var Ports)< 1 %
Table Column to Variable< 1 %- File Upload Widget< 1 %
- Extract Variables (Data)< 1 %
- Loop End (Column Append)< 1 %
- Table Row to Variable< 1 %
Variable to Table Row< 1 %CSV Writer< 1 %- IF Switch< 1 %
- Date&Time Input (legacy)< 1 %
- Concatenate< 1 %
- Merge Variables< 1 %
- Try (Variable Ports)< 1 %
- String Manipulation< 1 %
- Amazon S3 File Picker (legacy)< 1 %
- String to Path (Variable)< 1 %
- Delete Files (legacy)< 1 %
- Extract URI Info< 1 %
- URI Port to Variable< 1 %
Database SQL Executor< 1 %Database Writer< 1 %- Interactive Table (legacy)< 1 %
- Distance Matrix Writer< 1 %
Python Edit Variable< 1 %Binary Objects to Files< 1 %- Create Directory (legacy)< 1 %
- Active Branch Inverter< 1 %
CSV Reader< 1 %- Chunk Loop Start< 1 %
- Reference Row Filter< 1 %
- String Manipulation (Variable)< 1 %
- SDF Writer< 1 %
- File Download (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Parameter Optimization Loop Start< 1 %
- Python Source (legacy)< 1 %
String Input (legacy)< 1 %- Testflow Configuration< 1 %
- String to URI< 1 %
Table Row to Variable< 1 %Database Reader< 1 %Line Reader< 1 %- Missing Value< 1 %
- Empty Table Creator< 1 %
- Table Row to Variable Loop Start< 1 %
- Rule-based Row Filter< 1 %
- Histogram (legacy)< 1 %
Excel Reader (XLS)< 1 %Flow Variable End IF< 1 %- URI to String< 1 %
Extract Context Properties< 1 %Recursive Loop End (2 ports)< 1 %Recursive Loop End< 1 %- Duplicate Row Filter< 1 %
Joiner< 1 %Table Row To Variable Loop Start< 1 %- Output File< 1 %
- Output Files< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Copy/Move Files (legacy)< 1 %
- Upload (legacy)< 1 %
Variable to Table Column< 1 %- Java Edit Variable (simple)< 1 %
- Boolean Input (legacy)< 1 %
Python Source< 1 %- Read Variables< 1 %
- Run Garbage Collector< 1 %
- TextExporter< 1 %
- List Remote Files (legacy)< 1 %
Model Reader< 1 %- Double to Integer< 1 %
- Ungroup< 1 %
- Rule Engine Variable< 1 %
- Statistics< 1 %
- Column Expressions< 1 %
Excel Reader (XLS)< 1 %- Credentials Input (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Unzip Files (legacy)< 1 %
- Wait...< 1 %
- Create File Name (legacy)< 1 %
Table Column to Variable< 1 %- Java Edit Variable< 1 %
Counting Loop Start< 1 %Interval Loop Start< 1 %Variable Condition Loop End< 1 %Recursive Loop Start< 1 %CASE Switch Data (End)< 1 %- Math Formula< 1 %
- Math Formula (Variable)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
Dummy Input (legacy)< 1 %Value Selection QuickForm (legacy)< 1 %- R to Table< 1 %
Input File< 1 %- Catch Errors (Generic Ports)< 1 %
- CSV Reader< 1 %
Cell Splitter< 1 %- Sorter< 1 %
CASE Switch Model (Start)< 1 %- Value Selection Configuration< 1 %
- Text Output (legacy)< 1 %
Date Input (legacy)< 1 %- Column Selection (legacy)< 1 %
- Container Input (Credentials)< 1 %
- Container Input (Table)< 1 %
- GET Request< 1 %
- StringCell To File< 1 %
- Timer Info< 1 %
Flow Variable IF Switch< 1 %- Table Row To Variable Run-for-time Loop Start< 1 %
- Download (legacy)< 1 %
- File Meta Info (legacy)< 1 %
- Port to URI< 1 %
- URL to File Path< 1 %
- URL to File Path (Variable)< 1 %
- Breakpoint< 1 %
Database Row Filter< 1 %Database Update< 1 %Database Table Selector< 1 %File Reader< 1 %List Files< 1 %Table Reader< 1 %- Feature Selection Loop End< 1 %
Loop End< 1 %Variable Loop End< 1 %Column Appender< 1 %- Constant Value Column< 1 %
- Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Reference Column Resorter< 1 %
- Row Sampling< 1 %
- Unpivot< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Variable (Start)< 1 %- End IF< 1 %
CASE Switch Data (Start)< 1 %- SDF Reader< 1 %
- Explorer Browser< 1 %
- Java Snippet (simple)< 1 %
- Double Input (legacy)< 1 %
- File Upload (legacy)< 1 %
- String Input (legacy)< 1 %
Python Script (1⇒1)< 1 %- Python Edit Variable (legacy)< 1 %
- R Snippet< 1 %
- Table to R< 1 %
- POST Request< 1 %
Loop End (Upto 6 ports)< 1 %- Chunk Loop Run-for-time Loop Start< 1 %
- Table Row To Variable Run-to-time Loop Start< 1 %
Wait-for-time< 1 %Wait-to-time< 1 %- Run Heavy Garbage Collector< 1 %
- Binary Objects to Strings< 1 %
- FTP Connection (legacy)< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Database Query< 1 %Database Connector< 1 %Database Drop Table< 1 %Backward Feature Elimination End< 1 %- Tree Ensemble Predictor< 1 %
- Auto-Binner< 1 %
- Column Auto Type Cast< 1 %
- Column Comparator< 1 %
- Cross Joiner< 1 %
- GroupBy< 1 %
- Number Rounder< 1 %
- RowID< 1 %
- String Replacer< 1 %
- Empty Table Switch< 1 %
- Cache< 1 %
- Data Generator< 1 %
- Color Manager< 1 %
- Save Workflow< 1 %
- Parallel Chunk Start< 1 %
- DB SQL Executor< 1 %
- Model Loop Start< 1 %
- Variable Expressions< 1 %
- SAS7BDAT Reader< 1 %
XLS Reader< 1 %Excel Sheet Appender (XLS)< 1 %- Java IF (Table)< 1 %
Word Vector Model Writer< 1 %- External Tool (Labs)< 1 %
- Nominal Row Filter Configuration< 1 %
- Boolean Configuration< 1 %
- Credentials Configuration< 1 %
- Date&Time Configuration< 1 %
- Repository File Chooser Configuration< 1 %
- Local File Browser Configuration< 1 %
- Integer Configuration< 1 %
- Line Plot (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- Credentials Widget< 1 %
- Date&Time Widget< 1 %
- Slider Widget< 1 %
- File Download Widget< 1 %
- Container Input (Row)< 1 %
- Container Output (Table)< 1 %
Variable Output (legacy)< 1 %- Date&Time to String< 1 %
- Date&Time-based Row Filter< 1 %
- Reset on Load< 1 %
Parquet Reader< 1 %- DB Query Reader< 1 %
DB Table Creator< 1 %Read Excel Sheet Names (XLS)< 1 %- Excel Reader< 1 %
- Create File/Folder Variables< 1 %
- Path to String (Variable)< 1 %
Views
- This node has no views
Workflows
(Optional)_Linear_RegressionKNIME Hub- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- 001_Variables - global 1KNIME Hub
- 002_Variables - variable nodes 1KNIME Hub
- 003_Variables - variable nodes 2KNIME Hub
- Show all 474 workflows
Links
- NMEA 183 Textfile auswerten und in Excel darstellenby knimediger on 2020-02-27forum.knime.com/p/82871
- linking one line of the test dataset to a text dataset without primary keyby AnotherFraudUser on 2020-05-27forum.knime.com/p/92541
- Beta CSV Array Reader NullPointerExceptionby mlauber71 on 2018-10-05forum.knime.com/p/48463
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.