How to sort the data table?

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 Sortedoutput

Can anyone guide me how to do this, Please?

1 Like

hi

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

thanks

2 Likes

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

2 Likes

Re-Order.xaml (5.1 KB)

Hi @jamunatj,

Hope this helps,

Cheers
@jamunatj

2 Likes

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

Thanks for your response @shaikmdrafi

You dont want this activity?

1 Like

Hi @jamunatj,

I used it in Assign activity like this:
image

Giovanni

1 Like

Okay Thanks @q.gio

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