activities
latest
false
UiPath logo, featuring letters U and I in white
Workflow Activities
Last updated Nov 26, 2024

Sort Data Table

UiPath.Core.Activities.SortDataTable

Description

Sorts an entire DataTable by ascending or descending order, based on the values of a specified column.

Project compatibility

Windows - Legacy | Windows | Cross-platform

Cross-platform configuration

  • DataTable - The DataTable variable you want to sort. This field supports only DataTable variables.
  • Column - The variable containing the name of the column you want to sort by.
Advanced options

Options

  • Order - The order in which the table is to be sorted. Ascending means the first value is the lowest, while Descending means the first value is the highest.

Output

  • Sorted Data Table - The DataTable variable after it has been sorted. Placing the same variable as the one in the DataTable field changes the initial variable while adding a new variable leaves the initial one unaffected. This field supports only DataTable variables.

Windows - Legacy, Windows configuration

Properties panel
Common
  • DisplayName - The display name of the activity.
Input
  • DataTable - The DataTable variable you want to sort. This field supports only DataTable variables.
Misc
  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output

  • DataTable - The DataTable variable after it has been sorted. Placing the same variable as the one in the Input: field changes the initial variable while adding a new variable leaves the initial one unaffected. This field supports only DataTable variables.

Sorting Column

  • Column - The variable containing the column you want to sort by. This field supports only DataColumn variables. Setting a variable in this property field disables the other two properties.
  • Index - The index of the column you want to search for. This field supports only Int32 variables. Setting a variable in this property field disables the other two properties.
  • Name - The name of the column you want to search for. This field supports only strings and String variables. Setting a variable in this property field disables the other two properties.
  • Order - The order in which the table is to be sorted. Ascending means the first value is the lowest, while Descending means the first value is the highest.

Example of using the Sort Data Table activity

Here you can see how the Sort Data Table activity is used in an example that incorporates multiple activities.

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.