Description

Adds a data row to a specified data table.



Properties

Input

  • ArrayRow - The array of objects to be added to the data table.

  • DataRow - The data row object to be added to the data table.

  • DataTable - The data table object to which the row would be added.

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  the initial Sequence. 
  3. In the Generate DataTable Data Table field under Properties, add the dt variable.
  4. In the 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. Add an Add Data Column activity, and in the DataTable field, add the dt variable.
  7. In the Add Data Column Column Name field, write "Age".
  8. Add another Add Data Row activity, and in the DataTable field, add the dt variable.
  9. In the second Add Data Row Array Row field, write {"4","Jane","26"}. 

    The use case should look as the following screenshot:



After the execution, the result should be a data table with its initial values, and then a column Age added into the data table, and a new data row with the specified values.