Filter error in activities also (812.4 KB)
Hi All,

I have an excel sheet need to remove th erows havinf “Plnt” and empty rows.
when i am trying to use filter table activity it is removing header also.

and if i am using ““Plnt <>‘’”). CopyToDataTable()” then is is showing me error line unknown column and sometimes comming “invalid operator”

Please help me to filter the rows accordingly

I have attahced the excel file, first i need to remove rows untill 66 and then i want to filter it for column “Plnt”

1 Like

Please Refer the below link

1 Like


what is your requirement u want to remove Blank row or col contains “Plant” both means
what is the columnName

Maybe you could take a look at Filter Datatable Activity.