How to sort the data table?

[jamunatj (jamuna)]

Hi,

I am having input data table like this input.xlsx (9.0 KB)
I need to sort the row of data table, The same login id row should be in the next row of data table like

Can anyone guide me how to do this, Please?

[shaikmdrafi (shaik mahammad raphi)]

hi

You can use the filter data table activity to get this, the result willl be in the output data table

thanks

[q.gio (Gio)]

Hi,

I think this should work in your case:

yourDatatable.AsEnumerable.OrderBy(Function(x) x(“LoginId”)).CopyToDataTable

This returns another datatable ordered for “LoginId”.

Regards, Giovanni

[Pradeep_Shiv]

Re-Order.xaml (5.1 KB)

Hi @jamunatj,

Hope this helps,

Cheers
@jamunatj

[jamunatj (jamuna)]

Thanks for your response @q.gio
How we should use this ? Can you explain me please

[jamunatj (jamuna)]

Thanks for your response @shaikmdrafi

[moenk (Thomas Meier)]

You dont want this activity?

Sort Data Table

[q.gio (Gio)]

Hi @jamunatj,

I used it in Assign activity like this:

Giovanni

[jamunatj (jamuna)]

Okay Thanks @q.gio