Skip to main content

Write CSV

Synopsis​

This operator is used to write CSV files(Comma-Separated Values).

Description​

A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form. CSV files have all values of an example in one line. Values for different attributes are separated by a constant separator. It may have many rows. Each row uses a constant separator for separating attribute values. The name suggests that the attributes values would be separated by commas, but other separators can also be used. This separator can be specified using the column separator parameter. Missing data values are indicated by empty cells.

Input​

input​

This input port expects an ExampleSet. It is output of the Retrieve operator in the attached Example Process.

Output​

through​

The ExampleSet that was provided at the input port is delivered through this output port without any modifications.This is usually used to reuse the same ExampleSet in further operators of the process.

file​

The created CSV file is provided as a file object that can be used with other operators with file input ports like 'Write File'.

Parameters​

Csv file​

path of the CSV file is specified here. It can be selected using the choose a file button.

Column separator​

Column separators for the CSV file can be specified here.

Write attribute names​

This parameter indicates if the attribute names should be written as the first row of the CSV file.

Quote nominal values​

This parameter indicates if the nominal values should be quoted with double quotes in the CSV file.

Format date attributes​

This parameter indicates if the date attributes should be written as a formatted string or as milliseconds past since January 1, 1970, 00:00:00 GMT.

Date format​

This parameter only appears when format_date_attributes is selected AND the operator compatibility level is set above 9.9.002. This allows you to specify the format the date should be written as in the CSV file.

Append to file​

This parameter indicates if new content should be appended to the file or if the pre-existing file content should be overwritten.

Encoding​

This is an expert parameter. There are different options, users can choose any of them.