datatable-to-csv-file

Export data from Data-flo into a CSV file for use outside of Data-flo.

Make use of your cleaned, harmonized data outside of Data-flo by exporting it into a CSV file (or other delimited format)

Arguments

Inputs:

data: Datatable

separator: Character used as column delimiter. Defaults to ',' (comma). For a TSV (tab-separated value), use backslash-t ('\t') or copy-paste a tab from a text editor (select the blank area - see image)

newline: Character used as row delimiter (the character in the CSV string that signifies the end of one row and the beginning of the next). Also known as line break, end of line, or carriage return. Must be one of '\r', '\n', or '\r\n'. Defaults to '\\n' (newline). TIP: holding <shift> while you hit <enter> (or <shift><return>) will allow you to type a newline character in the "Bind to a value" text box, rather than typing backslash-n or backslash-r.

columns: A list of all columns to be included in the output file. Defaults to null (empty), which includes all columns.

filename: The name of the output file, including the extension (e.g. '.csv', '.tsv'). Defaults to 'data.csv'. This is an input about an output.

Output:

output: The file in CSV (or TSV) format. The name of this file can be defined using the filename input.

TIP: Do not forget to select the output argument and "Mark as a Data-flo output" to make the output available outside Data-flo.

Example

Data-flo - Run: Adaptor Demo: datatable-to-csv-file - Data-flo

Possible use cases

• Save data processed in Data-flo as a CSV file.