Filter Column less than or equal to zero

Help Studio
1

Hi, I want to filter the excel column less than or equal to zero. How can I achieve this in excel itself.
Thanks

2

Do you mean remove the rows?

3

yes, to remove the rows

4

Hi @nagini.pragna ,

Hope you are doing well.

Please use below expression in Assign activity to filter the datatable for values less than 1

d1.asEnumerable.where(Function(x1) CInt(x1(“ColumnNameTobeFiltered”))<1).copyToDatatable

This expression will give a datatable with required rows. Let me know if you need any workflow.

1 Like
5

Load the sheet into a datatable with Read Range then use Filter Datatable to remove the rows, then write back to Excel with Write Range.

1 Like
6

Hi

Did we try with a simple method of using FILTER DATATABLE activity

https://docs.uipath.com/activities/docs/filter-data-table

Cheers @nagini.pragna

1 Like
7

Thanks For the reply, I tried using macros and it is working fine.

8

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