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

Help Forum
, , , , ,
1

1

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

.
.
.
Output I am looking:

2

Thank you in advance:)

2

Hi @mavsp8

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

image
image804×569 13.2 KB

3

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.

4

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