Remove duplicate rows or columns Version 1 (Net)

Action group: Tables

Description

The action is designed to remove duplicate columns or rows from the table.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Data tableThe table in which duplicates will be removed.Robin.DataTable
Yes
DeleteThe type of duplicate to remove.Robin.String
Yes

Special conditions of use

None.

Example of use 

Task

There is a table in CSV format with duplicated row

  

You need to delete the duplicate row and create a new table with the edited data. 

Solution

Use "Get table from CSV", "Remove duplicate rows or columns",  "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 "Remove duplicate rows or columns" 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 duplicate row has been deleted.