Description

Reads and stores the value of a specified column.



Attributes

Output

  • Values - The value of the column to be stored.

Input

  • Column - The column where the value would be read.

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

For this example, this is what the sample CSV document contains:



  1. Add a CSV Sequence on the initial Sequence. 
  2. In the CSV Sequence File Path field, search and select the CSV document that you will use.
  3. In the CSV Sequence Delimiter field, write ','.
  4. Create a Array of String (String[]) variable and name it col.
  5. Inside the CSV Sequence, add a CSV Read Column activity. 
  6. In the CSV Read Column Values field, add the col variable.
  7. In the Column field, write 1. This means this activity would read the data in the column index 1.
  8. Under the CSV Read Column, add a For Each activity.
  9. In the For Each activity Values field, add the col variable.
  10. Inside the For Each activity, add a Write Line activity.
  11. In the Write Line Text field, write item.ToString. This is to simply display the values of the retrieved column. 

    The use case should look as the following screenshot:



The output should look like this in the Output panel: