Filter datatable

I have datatable with columnames like[01-Jul-2017]till [30-Jul-2017] and additional columns also there .i want to filter a datable with current date and additional columns .i got current date using current date activity but i don’t know to filter the datatable.

You can Use Select method for filter the data table

For example

Datatable = VarDatatble.Select(“ColumnName=’”+CurrentDate+"’").CopyToDataTable

1 Like

i am getting one or more validation errors

can u attach the screen shot or workflow
Its working for me

Datatable

u can use the currDateValue in Write range activity

Attach u r workflow

Don’t use “Datatable=” in Write range activity

Still getting same error
In writeRange activity in datatable field i have given this:
currDateValue=dtRoster.Select(“ColumnName=’”+CurrentDate+"’").CopyToDataTable

Could u please attach u r work flow

test.xaml (16.6 KB)

Excel file?

test.xlsx (10.3 KB)

It is better practice to either create a new datatable or remove rows that you don’t want from the existing datatable. Then you can simply write your new or updated datatable to the Excel file.

The way you are doing it you have no idea what the problem is, how many rows you are exporting or if you are selecting the correct information.

1 Like

Thank you