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.

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