Set column values Version 4 (Net)

Action group: Tables

Description

This action is used to set values in the specified column of the table.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Data tableTable for which the action will be performed.Robin.DataTable
Yes
Column nameName of the column for which the data will be set. If the field is not filled, then the value from the «Column index» field is taken.Robin.String
No
Column indexIndex of the column from which the data will be retrieved. Indexing starts at 0. If the «Column name» field is filled in, the value in the «Column index» field is ignored. Default value is «0».Robin.Numeric
No
ValuesThe values to be written to the selected column.Robin.Collection
Yes

Special conditions of use

None.

Example of use 

Task

There is a table in CSV format 

   . 

You need to change the values in the PAGES column for the first 5 values to (111, 222, 333, 444, 555) and create a new table with the updated data. 

Solution

Use "Get table from CSV", "Set column values",  "Table to CSV" actions.

Implementation

  1. Assemble a robot consisting of actions:

  2. Set the parameters for the "Get table from CSV" action.

  3. Set the parameters for the "Set column values" action. In the "Values" field, the value numbered 0 must be PAGES , because it does not need to be changed. The other values in order are:  111, 222, 333, 444, 555. 
  4. Set the parameters for the "Table to CSV" action. 


  5. Click "Start" in the top panel.  

Result

The program robot completed successfully. 

The required values of the PAGES column have been changed.