Sort Datatable by two columns

Hi. I have a table that does not have headers and I have to sort it by Column A (from A6) ascending and by column M (from M6) from A to Z.
I don’t know how many rows I have because data always changes. There also can be empty cells in table.

(From x In datatable.AsEnumerable() Order By convert.ToInt32(x(“Column2”)), convert.ToString(x(“Column11”)) Select x).CopyToDataTable

1 Like


You can easily sort out your data table using sort data table activity.
if you dont know column name, you can also provide column index like 1, 2, 3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.