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
i am getting one or more validation errors
can u attach the screen shot or workflow
Its working for me
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
Excel file?
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.
Thank you