How to remove a row in a data table based on the content of two columns

[DaveF]

I populate a datatable from a scrape of a table on a web page. The data looks like the following:
[NAME,SCORE,TOTAL,DATED
Bob,0,1234,29/05/2019
Joe,NA,0,01/01/2018
Ken,0,0,22/11/2018
Rik,2345,0,22/11/2018
]

I would like to remove the rows where both Score and Total are 0 and or NA. If either has a value in it greater than 0 or that is not NA, then I want to keep the row.

I tried using an IF statement in a For each row and deleting the row if the conditions of the IF were met, but the For each row does not like it when you delete a row in the For loop. This makes sense because the new total number of rows has changed and would impact the loop.

How might I achieve removing the row based on two conditions?
(Score=“0” OR Score=“NA”) AND (Total=“0” OR Total=“NA”)

[PrasadGupta]

Hi @DaveF

Use Filter DataTable Activity.

Refer below documentation
https://docs.uipath.com/activities/docs/filter-data-table

Thanks

[DaveF]

Thanks. I don’t know how I missed that option but it is exactly what I needed.

For anyone reading trying to do the same thing I was able to set the filter rows to
Score=“0”
or Score=“NA”
and Total=“0”
or Total=“NA”

Worked perfectly.