Step: Convert CSV to Table (multi-line)

Converts a string stored in a variable by another step (e.g. Download File) to a table by splitting each line to create table row, and splitting on a delimiter (e.g. comma, pipe, etc.) to create columns in the row.

If the intended use of this step is to turn each row of this table into a graph, follow it with the Split Package by Table Row step and the Reify Table Row step.

Operates on table variable values

Allows Freemarker templates to select values

Use only with input that has line returns. To convert a single row of CSV to a table, use the Convert CSV to Table Row step.

  • Input Variable: the variable name from the package table. The default (for instance, a CSV file as an input to a playbook) is rawInput
  • Output Variable: the name you want to store the table in. You do not need to use the Freemarker $ syntax, just the name.
  • Replace Input Variable: Check this box to replace the CSV string in the package table with the newly-created table
  • Row Delimiter: The character in your data that represents a line break. Typically \r or \n. Use the Automatic checkbox to have the step pick from a list of common line-endings.
  • Column Delimeter: The character in your data that represents a column. Typically comma ,, pipe |, or tab \t.
  • First Row is Header: If checked, the first row of the CSV input is ignored to prevent it from becoming a row of data in the output table.
  • Collapse into one column per row: If checked, line endings are processed, creating multiple rows, but only one column is created with all cell values in that row being collapsed into one cell.
  • TRUE if the conversion is successful
  • FALSE if the input variable does not contain CSV data, or no match on the stated delimiters
  • step/convert-csv-to-table
  • Last modified: 2018/10/30 15:30