- Filter the records where Status is ‘Open’ ;
- Filter the records where Description is ‘Research Client Check Copy’ ;
- Filter the records where Date is newer than ‘1st of February 2018’ (discard older records);
- Append the resulting datatable into an Excel worksheet; you shouldn’t worry about the headers and format of the output file.
Use Filter Data Table activity and then add these three conditions.
https://docs.uipath.com/activities/docs/filter-data-table
Regards,
Karthik Byggari
Hi
If dt is the datatable variable then we can use Assign activity with SELECT method in it like this
dt = dt.Select(“[Status] = ‘Open’ AND [Description] = ‘Research Client Check Copy’ AND [Date] >= #" + from_date + "# ).CopyToDatatable()
And for this
We can use APPEND RANGE activity
For more details on date filter in select method
Cheers @MONALI_BHALERAO
Thank you
dt = dt.Select(“[Status] = ‘Open’ AND [Description] = ‘Research Client Check Copy’ AND [Date] >= #" + from_date + "# ).CopyToDatatable()
Thank you
1 Like