{"title":"CSV Writer","nodeType":"Sink","id":"*mPMx3pzMHtI9Qk5G","factoryName":"org.knime.base.node.io.filehandling.csv.writer.CSVWriter2NodeFactory","factoryId":"org.knime.base.node.io.filehandling.csv.writer.CSVWriter2NodeFactory","path":["IO","Write"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node writes out the input data table into a file or to a remote location denoted by an URL. The input data table must contain only string or numerical columns. Other column types are not supported.</p>\n             \n            <p><i>This node can access a variety of different</i> <a href=\"https://docs.knime.com/2021-06/analytics_platform_file_handling_guide/index.html#analytics-platform-file-systems\" rel=\"ugc nofollow noopener noreferrer\"> <i>file systems.</i> </a> <i>More information about file handling in KNIME can be found in the official</i> <a href=\"https://docs.knime.com/latest/analytics_platform_file_handling_guide/index.html\" rel=\"ugc nofollow noopener noreferrer\"> <i>File Handling Guide.</i> </a></p>\n            \n        \n        ","shortDescription":"Writes a data table into a CSV file.","keywords":[],"deprecated":false,"streamable":true,"tags":["IO","Write","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODg4N0UyMUU3RjI2MTFFNUE3NjBCMzY2NkE3NjU5N0EiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODg4N0UyMUQ3RjI2MTFFNUE3NjBCMzY2NkE3NjU5N0EiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo3OUNEOEJBOTJFMkYxMUU1OUMzRUMzQkRFMzNFNTk1RiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo3OUNEOEJBQTJFMkYxMUU1OUMzRUMzQkRFMzNFNTk1RiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PjkRNtEAAABpSURBVHjaYvz//z8DNsDIyIhdAg2w4JP8ONkar2b+3KMMTAwUAkZKvYDXBSDDQZifnx8rm6ABMPDnzx+s7CHkBZrGAoYBII1AwEisC5gosR2sFhRWeAKRkaJYIDsMiLUdpwtICUSAAAMA1LZTh55TvMQAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"The data table to write out."}],"outPorts":[],"dynInPorts":[{"groupName":"File System Connection","groupDescription":"The file system connection.","types":[{"objectClass":"org.knime.filehandling.core.port.FileSystemPortObject","color":"178ba5","dataType":"File System"}]}],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Output file","description":"The CSV file to write the data to.","optional":false},{"name":"Create missing folders","description":"If enabled, missing folders in the specified path will be created automatically.","optional":false},{"name":"If exists","description":"Specify the behavior of the node in case the output file already exists.\n<ul><li><b>Fail</b> : Will issue an error during the node&#39;s execution (to prevent unintentional overwrite).</li><li><b>Overwrite</b> : Will replace any existing file.</li><li><b>Append</b> : Will append the input data to an existing file.</li></ul>","optional":false},{"name":"File encoding","description":"You can select a predefined character set (UTF-8, UTF-16, etc.), or specify any other encoding supported by your Java VM. The OS default uses the default encoding of the Java VM, which may depend on the locale or the Java property &#34;file.encoding&#34;.","optional":false},{"name":"Compress file (gzip)","description":"Check this if you want to compress the output file using gzip compression.","optional":false},{"name":"Column delimiter","description":"The character string delimiting columns. A single tab character can be entered as &#39;\\t&#39;","optional":false},{"name":"Row delimiter","description":"Select the line break variation you want to use as row delimiter while writing the CSV file.\n<ul><li><b>System Default</b> : Use the line break of the operating system.</li><li><b>Linux/Unix Line break</b> : Use newline (\\n) as row delimiter.</li><li><b>Windows Line break</b> : Use carriage return &#43; newline (\\r\\n) as row delimiter.</li><li><b>Mac OS9 Line break</b> : Use carriage return (\\r) as row delimiter.</li></ul>","optional":false},{"name":"Write column headers","description":"If checked, the column names will be written out in the first line of the output file.","optional":false},{"name":"Don't write column headers if file exists","description":"If checked, the column headers will not be written when the output is appended to the already existing output file. This is particularly useful when the CSV Writer is used in a loop to report the results of each iteration.","optional":false},{"name":"Write RowIDs","description":"If checked, the RowIDs will be added to the output, as first item in each line.","optional":false},{"name":"Quote character","description":"The quote character used to enclose values with. See the &#34;Quote values&#34; option to specify what kind of values should be enclosed within quotes.","optional":false},{"name":"Quote escape character","description":"The character is used for escaping quotes inside an already quoted value.","optional":false},{"name":"Quote values","description":"Specify when to enclose values with quotes:\n<ul><li><b>Strings only</b> : Integer and floating point numbers are not quoted, all other data items are. (Selecting the decimal point as data separator will lead to an output that can&#39;t be read in again.) The quote character is escaped in quoted items.</li><li><b>If needed</b> : Quotes are only placed around a data item that contains the data separator or if it equals the missing value pattern. The quote character will be escaped if it appears in a quoted data item.</li><li><b>Always</b> : Every data item written out is placed between quotation marks. (The missing value pattern is not quoted though.)</li><li><b>Never</b> : No data item is placed between quotation marks. You should specify a replacement pattern for the column delimiter, if it occurs in the data item.</li></ul>","optional":false},{"name":"Replace column separator with","description":"Specify a replacement for the value used as a column separator. Used only if the &#39;Never&#39; option is selected for Quote values.","optional":false},{"name":"Replace missing values with","description":"Set this option to replace missing values from the input table with specific text when writing.","optional":false},{"name":"Number decimal separator","description":"Specify a character that is used as decimal separator for floating point numbers.","optional":false},{"name":"Use scientific format for very large and very small numbers","description":"Check this if you want very large and very small floating point numbers to be written in scientific notation (e.g., 1.0E9 instead of 1,000,000,000).","optional":false},{"name":"Append .0 suffix for decimal numbers without fractions","description":"Check this if you want to write every decimal value with .0 suffix even though the value doesn&#39;t contain any fractional part. (e.g., the value 12 will be written as 12.0 if it is coming from a decimal column). Use with caution as this could lead to unnecessary increase of the file size. This doesn&#39;t affect the way to write values from integer columns. The option is ignored if we are using a scientific format.","optional":false},{"name":"Write name of file creator (KNIME username)","description":"If checked, the login name of the user that created the file (probably you!) is inserted.","optional":false},{"name":"Write execution time","description":"If checked, a comment line with the current execution time and date is added.","optional":false},{"name":"Write input table name","description":"If checked, a comment line is added showing the name of the table the data was read from.","optional":false},{"name":"Write custom text","description":"If you check this, you can enter any free text, that will be added then to the comment header.","optional":false},{"name":"Custom text","description":"Enter the custom text to be added to the comment header.","optional":false},{"name":"Comment line marker","description":"If you have checked at least one of the content options, you must provide a comment line marker that is used as a prefix for each comment line.","optional":false},{"name":"Comment indentation","description":"Specify an indentation string, i.e., a prefix for every comment line.A single tab character can be entered as &#39;\\t&#39;.","optional":false}]}],"links":[{"text":"KNIME E-Learning Course: Write Data to a CSV File","url":"https://docs.knime.com/ap/latest/analytics_platform_file_handling_guide/#writer-nodes"}],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}