How to remove value is <=2 in excel

Help
1

I have excel sheet in that i want to remove values <=2 from one column how to do this

2

hi buddy @thima

Welcome back to uipath community

you can use FILTER DATATABLE ACTIVITY
There mention the datatable name in input datatable
–then mentiont the column name between double quotes as a string
–mention condition like <=
–mention the value as 2 in value session
–check the radio button REMOVE in the top left above the column heading in filter datatable wizard
–mention the output datatable name in the output as a variable of type datatable
Kindly try this and let know buddy
Cheers @thima

3

This one i tried not working

4

can i have a view on your xaml if possible
Cheers @thima

5

Untitled
Untitled1280Ă—1024 65.5 KB

6

may i know what was the issue you were facing @thima

7

No error is thowing up but in excel its not removing rows

8

create a new table in the output datatable of filter datatable wizard and try once buddy @thima

9

@thima

Store output of Filter dataTable Activity into another dataTable and then you have to write into Excel file.

I guess it’s removed the rows which doesn’t meet that condition. Print the output of Filter dataTable Activity and check it.

10

Thank you its working fine

1 Like
11

Hi @thima,

If you got the solution, please mark it as a solution.

Thanks and Regards,
Manoj Vijayakumar