Sorting columns without sort datatable activity

[Palaniyappan (Palaniyappan P)]

Hi

Have a view on this thread for complete referral

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

As you want to have it without sort activity use this expression in a assign activity

Dt = Dt.AsEnumerable().OrderBy(Function (row) Convert.ToInt32(row(“columnname”)).Select(Function (row) row).ToArray.CopyToDatatable()

For descending

Dt = Dt.AsEnumerable().OrderByDescending(Function (row) Convert.ToInt32(row(“columnname”)).Select(Function (row) row).ToArray.CopyToDatatable()

Cheers @Shoebmd