Filter and delete specific rows

[Loons]

Hello!
I have an excel column and I need to filter it that every row with 0 is shown. After that I have to delete all these rows.
How can I do this?

[Ellboy]

I’ve attached a template of a way to do this. All you need to do is the read the data in adn then use the datatable filter activity to remove the desired rows

Main.xaml (5.4 KB)

[Loons]

But when I start this I always get this error:

[Ellboy]

Try checking what the column name should be or use the index of the column instead

[Loons]

I tried it with the index because I don’t have a column name but it still doesn’t work. It’s always the same error

[Ellboy]

Can you send the excel file?

[Loons]

I’m not allowed to upload any attachment

[Ellboy]

Okay in the filter dattable activity did you change the number to 51 with no quotation marks?

[Loons]

yes, but it still doesn’t work

[Ellboy]

Can you send a screenshot of the filter wizard please?

[Loons]

[Ellboy]

Try removing the “add headers” attribute from the read rnage activity. I’ve got it working in this text scenario:
Test.zip (24.3 KB)

[Loons]

Thank you, it works