Filter error in activities also

[nsharma (neha sharma)]

ExportedSap.zip (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 “DT1.select(“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”

[anil5 (Anil Kumar Bandam)]

Please Refer the below link

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

[amaresan (Amaran)]

Hi,

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

[Cosmin_Ion_Nicolae (Ion Nicolae)]

Maybe you could take a look at Filter Datatable Activity.