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 …

Please Refer the below link [image] DataTable filtering with expressions Tutorials 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 …

Hi, 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.

Filter error in activities also

Help

anil5 (Anil Kumar Bandam) February 11, 2019, 5:48pm 2

Please Refer the below link

Topic		Replies	Views
Filter data table activity to remove empty rows Studio excel , studio , question , workflow_diff	7	566	January 26, 2024
How to use Filter Data Table activity? Help	2	2806	June 18, 2019
Remove filtered data from particular column in datatable Help	6	2703	October 22, 2019
Remove datarow Studio studio , question , activities_panel	8	223	February 4, 2025
Filter datatable without header Help activities	3	4640	April 7, 2019

Filter error in activities also

Related topics