I want to sort the datatable in such a way that the resulting datatable will have data arranged in the order of first column and the same values in second column should be grouped together. Initial datatable GN JMBWN Name 1 BBBB Arun 1 BBBB Ashwin 1 CCCC Vishwa 2 DDDD John 2 BBBB S…

Sorting datatable according to multiple columns

lrtetala (Lakshman Reddy) October 7, 2024, 8:55am 3

Can you try below query

dtAdultTable = dtAdultTable.AsEnumerable().
    OrderBy(Function(row) row("GN")).
    ThenBy(Function(row) row("JMBWN")).
    CopyToDataTable()

Regards,

Topic		Replies	Views
How to Sort a Column or Multiple Columns (in different Orders) in a DataTable Tutorials studio , faq	0	5097	September 14, 2022
How to sort Column A, then sort Column B grouped under the same value in Column A? Help studio	4	2412	March 30, 2019
How to sort a datatable by two columns? Help	4	14571	July 21, 2019
How to Sort datatable? Activities datatable , excel , robot , activities , studio , question	2	562	March 29, 2023
When I want to set multiple values in OrderBy of DataTable, how should I write it? Studio datatable , activities , studio	4	1059	December 18, 2021