datatable-to-csv-file
Export data from Data-flo into a CSV file for use outside of Data-flo.
Last updated
Export data from Data-flo into a CSV file for use outside of Data-flo.
Last updated
Make use of your cleaned, harmonized data outside of Data-flo by exporting it into a CSV file (or other delimited format)
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
: 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.
Save data processed in Data-flo as a CSV file.