Description

Enables you to select column and row separators according to which the data table is generated.



Attributes

Output

  • DataTable - The data table variable that would contain the data table.

Input

  • Input - The source of the unstructured data to be converted into a table.

Fixed Formatting Options

  • ColumnSizes - Defines the size of the column to be created in the table.

Formatting Options 

  • ColumnSeparators - Defines the character to be used as a column separator.

  • NewLineSeparator - Defines the character to be used as a new line separator.

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. Create a DataTable variable called dt.
  2. Add a Generate Data Table inside a Sequence, and in the DataTable field under Properties, add dt.
  3. In the ColumnSeparators field under Properties, write ";", and in the NewLineSeparator field, write "|".
  4. In the Input field, type "ID; Name; Age|1; Nicole; 26|2; John; 25|3; Michael; 27". This would be the sample values inside the data table.
  5. Create a String variable called dataTable.
  6. Add an Output Data Table activity, and in the Text field under Properties, write dataTable.
  7. In the DataTable field, add dt.
  8. Add a Message Box activity, and in the Content field, write dataTable.

    The use case should look like the following screenshot:



The output should be a Message Box containing the generated data table: