How to delete rows in datatable

[E.T.S]

I am using a filter data table activity - but when I configure the filter I only have the options of removing columns and not rows:
Here it is asking to filter rows but by column:

And here it asking for the output column:

How can I configure this to filter by row and not column?

I have also tried the delete row activity however this only removes the values in the row and not the row itself

[Aakash_Singh_Rawat]

Hi @E.T.S ,

In Filter Rows tab, you have to provide column/s value/s or condition so your rows will be removed.

Example you want to remove rows where column named “State” value = “UP”
In that case, you will provide value “UP” in Value and Operation will = and Column will be “State”

[Shiva_Nikhil]

@E.T.S

mention any column name and pass the value

if that matches then the entire row will be deleted

cheers