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 WriterThis node writes out the input data table into a file or to a remote location denoted by an URL. The node
provides many options to customize the output format (see below). But there is no checking done on the
settings, so it is possible to write out the data in a format that makes it impossible to read it in again
(e. g. if you specify no data separator).
Note that if the destination location is a remote URL not all options are available because in general it's
not possible to determine whether the remote location exists. In this case it will always be overwritten.
Options
Settings
General settings regarding the output file location and formats.
Advanced
In the Advanced tab, you can specify the character(s) that will be written out between the data items.
Quotes
In the Quotes tab, you can enter a left and right quotation mark pattern. Also, select a mode, which determines when quotation marks should be placed around the data item. When quotes are used (in every mode other than "never") you must also specify a replacement pattern for the right quote. If it appears in the data item, it must be replaced (so it won't be confused with the actual closing quote).
Comment Header
In the Comment Header tab you can add a comment header to the beginning of the output. Either specify your own comment line(s) or choose from the predefined items. If you check one of the options you must also enter a comment begin and comment end pattern.
Number Format
In the tab "Number Format" you can define the decimal separator and whether scientific notation should be used.
Encoding
Popular Successors
Variable Condition Loop End3 %- Java Edit Variable3 %
String Replace (Dictionary)3 %Loop End (2 ports)3 %- Catch Errors (Var Ports)3 %
Table Row to Variable2 %- Reference Row Filter2 %
- Copy/Move Files (legacy)2 %
Variable to Table Column2 %Table Row To Variable Loop Start2 %Table Writer2 %- Legacy Date&Time to Date&Time1 %
- Date&Time Input (legacy)1 %
- R Snippet1 %
Scorer1 %- Text Output (legacy)1 %
- FTP Connection (legacy)1 %
- GroupBy1 %
- R Snippet1 %
Excel Writer (XLS)1 %- Parallel Chunk End< 1 %
- List Remote Files (legacy)< 1 %
- Amazon S3 Connection (legacy)< 1 %
- Timer Info< 1 %
JSON Writer< 1 %XLS Writer< 1 %- Write Variables< 1 %
- File Download (legacy)< 1 %
Input File< 1 %Simple File Reader< 1 %Google Authenticator (Deprecated)< 1 %- Partitioning< 1 %
- Delete Files (legacy)< 1 %
- Unzip Files (legacy)< 1 %
Excel Sheet Appender (XLS)< 1 %- Empty Table Creator< 1 %
- Create Directory (legacy)< 1 %
File Reader< 1 %Merge Variables< 1 %- SDF Reader< 1 %
- Column Filter< 1 %
Column Rename< 1 %- String Manipulation (Variable)< 1 %
- Rule Engine< 1 %
Generic Loop Start< 1 %Row Filter (deprecated)< 1 %Joiner< 1 %CASE Switch Variable (End)< 1 %- External SSH Tool< 1 %
Python Script (2⇒1)< 1 %- URL to File Path (Variable)< 1 %
Variable Loop End< 1 %- Rule-based Row Splitter< 1 %
CASE Switch Variable (Start)< 1 %XLS Reader< 1 %- R Source (Table)< 1 %
- Download / Upload from List (legacy)< 1 %
Database Connector< 1 %- Reference Row Splitter< 1 %
- Value Counter< 1 %
- Python Source (legacy)< 1 %
- Table Creator< 1 %
Row Splitter (deprecated)< 1 %Vertica Connector< 1 %- DB Query< 1 %
MongoDB Writer< 1 %- Destroy Spark Context< 1 %
- Math Formula< 1 %
Excel Reader (XLS)< 1 %- Container Input (Credentials)< 1 %
- Table to HTML String< 1 %
Variable to Table Row< 1 %- Feature Selection Loop End< 1 %
- Column Resorter< 1 %
- Data Generator< 1 %
- Distance Matrix Reader< 1 %
- String Input (legacy)< 1 %
- Zip Files (legacy)< 1 %
Table Reader< 1 %Loop End< 1 %- Column List Loop Start< 1 %
- Constant Value Column< 1 %
MySQL Connector< 1 %- Dictionary Replacer (File-based)< 1 %
- Google Sheets Updater< 1 %
- R to Table< 1 %
Variable to Table Row< 1 %- Fixed Width File Reader< 1 %
- X-Aggregator< 1 %
- Numeric Binner< 1 %
Column Appender< 1 %- Pivot< 1 %
- RowID< 1 %
- Table Transposer< 1 %
CASE Switch Data (Start)< 1 %- DB Query Reader< 1 %
- File Chooser (legacy)< 1 %
- XPath< 1 %
Image Writer (Table Column)< 1 %Model Writer< 1 %- Merge Variables< 1 %
- Color Manager< 1 %
- Parallel Chunk Start< 1 %
Excel Reader (XLS)< 1 %- File Upload (legacy)< 1 %
- File Download Widget< 1 %
Python Edit Variable< 1 %Flow Variable End IF< 1 %Loop End (Upto 6 ports)< 1 %- Run Garbage Collector< 1 %
- URL to File Path< 1 %
CSV Reader< 1 %- Save Workflow< 1 %
Amazon Redshift Connector< 1 %Tableau Writer (Hyper)< 1 %- Time to String (legacy)< 1 %
Python Snippet< 1 %Database Connection Table Reader< 1 %- Java Snippet< 1 %
- Cross Joiner< 1 %
- Rule-based Row Filter< 1 %
- Send Email< 1 %
- Scatter Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- TimeDelay Loop End< 1 %
- CSS Editor< 1 %
- Memory Use< 1 %
- String to URI< 1 %
- Upload (legacy)< 1 %
- Wait...< 1 %
- Try (Variable Ports)< 1 %
- Create File Name (legacy)< 1 %
Image Writer (Port)< 1 %- CSV Array Reader< 1 %
Database Query< 1 %- Loop End (Column Append)< 1 %
Tree Ensemble Predictor< 1 %Concatenate (Optional in)< 1 %Cell Replacer< 1 %- Global Timer Info< 1 %
- PostgreSQL Connector< 1 %
- DB Insert< 1 %
- Parameterized DB Query Reader< 1 %
- DB Reader< 1 %
- Voting Loop End< 1 %
- Java Edit Variable (simple)< 1 %
- Python Object Reader (legacy)< 1 %
File Download (legacy)< 1 %- R Source (Workspace)< 1 %
- File Difference Checker< 1 %
- Test FileStore Port Object Loop End< 1 %
- KNIME Server Connection (legacy)< 1 %
- Download (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
CSV Writer< 1 %List Files< 1 %- Chunk Loop Start< 1 %
- Group Loop Start< 1 %
Recursive Loop End< 1 %- String Manipulation< 1 %
- End IF< 1 %
- DB Writer< 1 %
- External Tool< 1 %
- File Upload Widget< 1 %
- Container Input (JSON)< 1 %
- Parameter Optimization Loop End< 1 %
Python Script (1⇒1)< 1 %- Python Edit Variable (legacy)< 1 %
- RDKit Interactive Table< 1 %
- ZipLoopEnd< 1 %
- Breakpoint< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %Database SQL Executor< 1 %- Cell Splitter< 1 %
- Mol2 Reader< 1 %
- MySQL Connector< 1 %
- DB Table Remover< 1 %
- Variable Expressions< 1 %
Container Input (Variable)< 1 %Python Script (1⇒1)< 1 %- R Learner< 1 %
- Create Date&Time Range< 1 %
- Message Slack channel< 1 %
- Benchmark End< 1 %
- SSH Connection (legacy)< 1 %
Catch Errors (DB Ports)< 1 %Database Reader< 1 %Database Drop Table< 1 %Counting Loop Start< 1 %Recursive Loop End (2 ports)< 1 %Recursive Loop Start (2 ports)< 1 %- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
- Sorter< 1 %
- Data Explorer< 1 %
- Spark to Table< 1 %
- Amazon S3 File Picker (legacy)< 1 %
DB Loader< 1 %- DB Table Selector< 1 %
Word Vector Model Reader< 1 %Stop Word Filter< 1 %- Integer Input (legacy)< 1 %
- R to R< 1 %
- Data to Report (BIRT)< 1 %
- Quit WebDriver< 1 %
- Wait< 1 %
- Input Files< 1 %
- Output Folder< 1 %
- Variable Timed Loop End< 1 %
- PDB Saver< 1 %
- URI Port to Variable< 1 %
- URI to Port< 1 %
- Active Branch Inverter< 1 %
Database Connection Table Writer< 1 %Database Delete< 1 %Database Writer< 1 %List Files< 1 %- Feature Selection Loop Start (1:1)< 1 %
K Nearest Neighbor< 1 %- SVM Predictor< 1 %
- Reference Column Filter< 1 %
- Reference Column Resorter< 1 %
- Row Sampling< 1 %
CASE Switch Data (End)< 1 %- Histogram (legacy)< 1 %
- Hive Connector< 1 %
- Explorer Writer< 1 %
- Math Formula (Variable)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Excel Reader (XLS)< 1 %- Java Snippet (simple)< 1 %
- Java IF (Table)< 1 %
- External Tool (Labs)< 1 %
- Image Output (legacy)< 1 %
- Column Filter (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Container Output (Table)< 1 %
- Don't Save End< 1 %
Python Source< 1 %- Python View (legacy)< 1 %
- POST Request< 1 %
- Time Generator (legacy)< 1 %
- Web Log Reader< 1 %
- RDKit From Molecule< 1 %
- HTML Parser< 1 %
- TableToFile< 1 %
Flow Variable IF Switch< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Read Variables< 1 %
- PDB Loader< 1 %
- SpecLibCreator< 1 %
- Create Collection Column< 1 %
- File Meta Info (legacy)< 1 %
- HTTPS Connection (legacy)< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Database Table Selector< 1 %Line Reader< 1 %PMML Reader< 1 %Interval Loop Start< 1 %- X-Partitioner< 1 %
- Random Forest Learner (Regression)< 1 %
- Perl Scripting< 1 %
- Concatenate< 1 %
Cell Splitter< 1 %- Column Combiner< 1 %
Number To String< 1 %- Missing Value< 1 %
- Numeric Row Splitter< 1 %
- Ungroup< 1 %
- Rule Engine Variable< 1 %
- Rule Engine (Dictionary)< 1 %
- One-way ANOVA< 1 %
- Statistics< 1 %
- Empty Table Switch< 1 %
- Create Temp Dir (legacy)< 1 %
- Extract Table Dimension< 1 %
- Line Plot (legacy)< 1 %
Hive Connector< 1 %- Azure Blob Store Connection (legacy)< 1 %
PostgreSQL Connector< 1 %- Microsoft SQL Server Connector< 1 %
- Oracle Connector< 1 %
- DB Connector< 1 %
- DB Connection Closer< 1 %
- DB SQL Executor< 1 %
- Boosting Predictor Loop End< 1 %
Table to HTML< 1 %XLS Sheet Appender< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Send to Tableau Server (Hyper)< 1 %- PubMed Document Parser< 1 %
- Local File Browser Configuration< 1 %
- Column Selection (legacy)< 1 %
- File Chooser Widget< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
- JSON Path< 1 %
Python Object Reader< 1 %- Table to R< 1 %
- Triple File Reader< 1 %
- Logger Option< 1 %
- Extract Time Window (legacy)< 1 %
XML Reader< 1 %- Start WebDriver< 1 %
Views
- This node has no views
Workflows
_Looping_over_all_columns_and_manipulation_of_each 1KNIME Forum- (Optional)_Linear_RegressionKNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- 00_KNIME_Workshop_basicsKNIME Hub
- 00_Scalable_Data_GenerationKNIME Hub
- Show all 535 workflows
Links
- KNIME E-Learning Course: Write Data to a CSV Filewww.knime.com/knime-introductory-course/chapter4/section1/write-data-to-a-csv-file
- Table to txt or xlsby qqilihq on 2019-11-19forum.knime.com/p/75108
- How to transform XML data to a tableby armingrudd on 2020-02-12forum.knime.com/p/81270
- Write multiple input CSV files to single CSV file and the end of a flowby mlauber71 on 2019-06-28forum.knime.com/p/63621
- Recursive loop end with more that one output portby armingrudd on 2019-08-06forum.knime.com/p/67170
- Show all 6 links
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.