Description

Writes a data table to a string using the CSV format.



Attributes

Output

  • Text - The data table output as string.

Input

  • DataTable - The data table object to be written into a string.

Common

  • ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.

Misc

  • DisplayName - Renames the activity.


Example

  1. Add a Generate Data Table inside the initial Sequence.
  2. Create a DataTable variable called dt. Select Sequence as its Scope. 
  3. In the Generate Data Table DataTable field under Properties, add the dt variable.
  4. In the Generate Data Table ColumnSeparators field under Properties, write ";", and in the NewLineSeparator field, write "|".
  5. In the Generate Data Table Input field, type "1; Nicole|2; John|3; Michael". This would be the sample values inside the data table.
  6. Create a String variable called dataTable. Select Sequence as its Scope.
  7. After the Generate Data Table, add an Output Data Table. 
  8. In the Text field under Properties, add the dataTable variable.
  9. In the Output Data Table DataTable field, add the dt variable. 

    The use case should look as the following screenshot:



After the execution, the data from dt DataTable variable should be stored in the String variable dataTable.