Description

Gets the value from a data row variable according to a specified column.



Attributes

Output

  • Value - The column value from the specified data row.

Input

  • Column - The data column object whose value is to be retrieved from the data row. If this property is set, then the ColumnIndex and ColumnName properties are ignored.

  • ColumnIndex - The index of the column whose value is to be retrieved from the data row.

  • ColumnName - The name of the column whose value is to be retrieved from the data row. If this property is set, then the ColumnIndex property is ignored.

  • Row - The data row object from which a value is to be retrieved.

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 activity inside the initial Sequence.
  3. In the Generate DataTable activity 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 a For Each Row activity, and in the DataTable field, add the dt variable.
  7. Create an Int32 variable called rowItem.
  8. Add a Get Row Item activity inside the Body sequence, and in the Value field under Properties, add the rowItem variable.
  9. In the Get Row Item Row field, add Row, and in the Column Index field, write 1
  10. Add a Write Line activity after the Get Row Item activity.
  11. In the Write Line activity Text field, add the rowItem variable:



The output should look like this in the Output panel: