Get a particular record in a datatable

Help Activities
, , ,
1

I have a datatable with several columns.

In this case, there are more than 11 columns.

Using for each row in a datatable, if a cell value is equal to today’s date,
the bot have to get the current row into another datatable.

Can someone please advise me what to do ?

2

HI @jhivesh.subron

Try this expression

dt.AsEnumerable().Where(Function(r) r(“Column name or Index”).Equals(DateTime.now.ToString(“Your Format or the format in the excel”))).CopyToDataTable

Then use write range in another sheet or excel

Hope this helps

Regards
Sudharsan

2 Likes
3

Hi @jhivesh.subron ,
use below query to get the current date value to another table.
dtNew=dt.select("ColumnName]='"+Now.ToString("MM/dd/yyyy")+"'").CopyToDataTable()

Regards,
Arivu

2 Likes
4

Use the Filter DataTable activity and put the filter condition for the column

5

Hi @jhivesh.subron

You can use Filter DataTable and of course we do this in multiple ways.

Please have a look on the below thread.

Thank you.

2 Likes
6

Hi @jhivesh.subron ,

You can use the Filter Data table activity to filter as per required with the Expression.

Thanks,

1 Like
7

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