Custom Sort Multiple Columns

[Md_Hidayat]

Hi all,
Is there a way to custom sort on multiple columns with datatable?
The current Sort Table Table activity only accepts 1 column name.

I would like to sort on two columns, Tax Invoice No. and Status. Thanks for the help in advance!

Book1.xlsx (10.9 KB) - Example File

Raw Sheet

Sort Preference

Desired Result

Regards
Hidayat

[vishal.kp (vishal)]

Hi @Md_Hidayat ,

Refer to the following thread, it explains the sorting of data table based on multiple columns.

How to Sort a Column or Multiple Columns (in different Orders) in a DataTable

This thread will help you to sort a column or Multiple Columns of Data Table using some simple techniques. Suppose if we have a Data Table having 2 columns as shown below. [image] 1. To Sort data in Ascending Order based on Column “KeyWord” using Linq Query :

Sort a column in Ascending Order using LinQ

Expression : InputDt = (InputDt.AsEnumerable.OrderBy(Function(x) x(“KeyWord”).ToString)).CopyToDataTable Result : [image]

2. To Sort data in Descending Order based on Column “KeyWord” usin…

Regards,

[Yoichi]

Hi,

How about the following?

dt = dt.AsEnumerable.OrderBy(Function(r) r("Tax Invoice No.").ToString).ThenBy(Function(r) if(r("Status").ToString.IsNumeric,CDbl(r("Status").ToString),0)).CopyToDataTable

Sample20230418-5L.zip (14.7 KB)

If you can ignore blank cell in Status column, SortRange activity also help you.

Regards,

[Gokul_Jayakumar (Gokul Jai)]

Hello @Md_Hidayat
You Can sort Multiple columns by using the Excel Modern Activity

If you are classic user, try this to enable the Modern activity,

1. Click Filter icon in Activity Panel
2. Enable the Moder option,
3. Now search the Excel application scope and Sort Range.
   
   

[Md_Hidayat]

Thank you Vishal!