Sort Version 3 (Net)

Action group: Tables

Description

This action is used to sort the values in the table by the specified column.

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 by which the table will be sorted. If the field is not filled, then the value from the «Column index» field is taken.Robin.String
No
Column indexIndex of the column by which the table will be sorted. 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
OrderSort order.Robin.String
No

Special conditions of use

None.

Example of use 

Task

There is a table in CSV format 

. 

You need to sort the values in column B in ascending order and save a copy of the table with the sorted data. 

Solution

Use "Get table from CSV", "Sort",  "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 "Sort" 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 data is sorted in a new table.

 

  • Нет меток