Description

Updates the value of a specified column.



Attributes

Input

  • Column - The column whose value would be updated.

  • Values - The new value to replace the existing value on the column.

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 in 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. Inside the CSV Sequence, add a CSV Update Column activity.
  5. In the CSV Update Column Column field, write 2. This would update the column in index 2.
  6. In the CSV Update Column Values field, write {"AGE","24","25","24"}. 
    (This will change the values of age from 23, 24, 25 to 24, 25, 24.)

    The use case should look as the following screenshot:



After the execution, the values of the specified column should be updated.