Delete column Version 3 (Net)

Action group: Tables

Description

Deletes the specified column with a left shift.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Data tableTable for which the action will be performed.Robin.DataTable
Yes
Column nameThe name of the column to be deleted.Robin.String
No
Column indexIndex of the column to be removed. 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

Special conditions of use

None.

Example of use 

Task

There is a table in CSV format 

   

You need to PRICE column and create a new edited document. 

Solution

Use "Get table from CSV", "Delete column",  "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 "Delete column" action.
  4. Set the parameters for the "Table to CSV" action. 


  5. Click "Start" in the top panel.  

Result

The program robot completed successfully. 

The PRICE column has been removed.

 

  • Нет меток