How can write this condition if condition

  • 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