How can i remove entire row based on specific text in a column?


I want to remove entire row if Column “Status” contains text->(“Not Paid”)

Output I am looking:


Thank you in advance:)

Hi @mavsp8

After reading the data using read range use a filter datatable activity like this

Use the Excel activities to read the data into a datatable. Use Filter Datatable to get rid of the rows you don’t want. Write remaining data to a new file. Delete the old file.

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