Remove Data Row with condition

Hi all,

I have the data like this and need to remove the row that the year of JobTerminationDate +3 >= Current Year.

Please suggest a solution on this.


This will help


hi @tantang1308 ,

  1. Read the Excel in a DataTable Say dt_Input.
  2. Use Filter DataTable Activity and pass The DataTable as Input. If you want to do the Changes in Same DataTable use dt_input in Output DataTable also
    3.In Row Filtering Mode : Select Remove and Specify the Condition. Sample Shown below.
  3. Here You also have an option of Keeping/ removing Certain columns - Use the Tab Output Columns.
  4. Once Competed - You can use the Output DataTable to Write into Excel / as per automation need.


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.