How can I custom sorting of one sheet's single column values by other sheet's column value?

Hi,

could you please explain about the values of assign activity? is it a VB function, specially “Enumerable” one?

It’s LINQ expression of VB.net. AsEnumerable method returns IEnumerable<DataRow> and has it enable to use LINQ. “Where” method works like filter. It filters out row which do not match the condition: each item in Column “SL No” of dt1 exists in Column “SL No” of dt2.

The following topic might also help you.

Can I use lookup activity here to get same kind of result?

In this case, probably we can achieve it using LookUp DataTable Activity and loop.

Regards,

1 Like