How sort column by custom?

[fairymemay (noona)]

How sort column by custom ?

If i want sort column by custom list.

[balupad14 (Balamurugan)]

Hi @fairymemay,

Take a look thread.

Sort DataTable with Multiple Columns(in a For Each)

Hi @ercan.nebiler, Take a look this thread with example [UiPath Sorting multiple columns|Sort Excel |Excel Automation|UiPath RPA Tutorial (BalaReva)] Thank you Balamurugan.S

Regards
Balamurugan.S

[Gopi_Arumugam]

Hi @balupad14 ,

I have a datatable lets say
|A|B|C|
|1|2|Two|
|3|5|Three|
|2|3|One|
And I would like to sort it by A (ASC) then B (ASC) and C by custom order (Two,One,Three) simultaneously so it would look like this.
|A|B|C|

|1|2|Two|
|2|3|One|
|3|5|Three|

I have been searching for this issue from last one month…i didn’t found any solution. The exact query was asked by another person…there also no has answered…can you please provide an solution for this?

[ppr (Peter)]

How to sort data table by custom sort

@fairymemay As IT IS Not a sorting on Letter ASC or desc you can customized e.g with the Help of dictionary or Array Index Define a dictionary of String, int Add items to IT dictSort(“inter”)=0, local 1… So with the lookup from value to Level IT can be sorted by Yourdatatablevar.asenumerable.orderby(function(r ) dictSort(r(indexorcolname).toString.trim)).copytodatatable

[balupad14 (Balamurugan)]

Hi @Gopi_Arumugam ,

Please take a look this video.

Sort Excel By Latest Date

Hi @jenkim, Here is the video explanation that how to sorting the excel based one column (s) [UiPath Sorting multiple columns|Sort Excel |Excel Automation|UiPath RPA Tutorial (BalaReva)] Thank you Balamurugan.s

Thank you
Balamurugan.S