Lets say I need to sort my dataTable (made from a Excel document) by 3 columns, lets name them: ID (not unique) Age Money so first, I will sort by ID, then age and then money, without losing the past sorting. any idea how to make it in UiPath?

@MaxyArthes [image] How to sort Column A, then sort Column B grouped under the same value in Column A? Help Given: Datatable with 2 columns: CA | CB 1 | B 2 | B 2 | A 1 | C 1 | A Problem: Sort the two columns like below: CA | CB 1 | A 1 …

@MaxyArthes use Sort Data Table activity to sort the DataTable.

using 3 back to back will keep the past sorting? and I forgot to mention, but the ID column is actually a text column in Excel, so I must also force Excel to treat them as number before sorting

Hi @MaxyArthes Fine as you mentioned three consecutive sort datatable activity will keep the previous sorting made…So that would work for sure buddy. Then ID column though being text format it will get sorted out as well. Kindly try this and let know for any queries or clarification You were alm…

The ID column don’t get sorted, probably because its strings =/

Oh…! does that column with string contains any special character in it buddy Cheers @MaxyArthes

Using ‘Invoke Code’ ? Getting a syntax error so I might just not be using the good activitie

@MaxyArthes Using Assign Activity

[image] Vijay_Tulsalkar: Using Assign Had to switch int16 to int32, working perfectly, thanks you :slight_smile:

@MaxyArthes Glad it Worked, Happy Automating… Cheers

Hi all, Here is the solution without using datatable, can able to do the multiple sorting. [image] UiPath Go ! BalaReva EasyExcel Activities Marketplace Hi all, Here is the video demonstration for Multiple columns Sorting… [UiPath Sorting multiple columns|Sort …

Sort Excel by multiple column

Help

Vijay_Tulsalkar (Vijay Kumar C Tulsalkar) June 17, 2019, 1:34pm 5

@MaxyArthes

(From x In datatablevariable.AsEnumerable() Order By convert.ToInt16(x(“ID”)),convert.ToString(x(“Age”)),convert.ToString(x(“Money”)) Select x).CopyToDataTable

How to sort a datatable by two columns?

Topic		Replies	Views
Data Table sort some columns Activities uiautomation , studio	2	66	July 26, 2024
Sorting columns without sort datatable activity Studio studio , question , activities_panel	10	2997	January 23, 2022
How sort column by custom? Help excel , activities , question	5	2772	April 1, 2021
How to sort a datatable by two columns? Help	4	14799	July 21, 2019
Custom Sort Multiple Columns Studio studio , question , activities_panel	5	2629	April 21, 2023

Sort Excel by multiple column

Related topics