Remove row of excel if one cell has "0%" value

Help Studio
1

Hey Guys

I have one excel file in that data is in tabular format
Now in column sixth , if one cell have " 0.00% " then i have to delete entire row

please tell me how to do this
clearly steps

2

hey

you can use lookup activity to filter that column, then use the delete row activity, and the use write range activity again to paste that data,

Regards!

3

Hi @Shoebmd ,
You can read your excel data using Read Range which outputs a Datatable, then you can use Filter datatable activity and pass the necessary condition .That will generate a filtered datatable and the you can use write range to write it to a new excel sheet

image

4

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