Hi, i have excel file in that Particular Column Name is Assignment column have to filter filter only numeric values 2.remove empty row save into new sheet [image] How to do it ? can any one help ? Filter.xlsx (9.2 KB)

[grafik] find starter help: FilterAsiignment_V2.xaml (8.3 KB)

Hi Hope this expression would help you resolve this dt = dt.AsEnumerable().Where(Function(a) Isnumeric(a.Field(of String)(“Assignment”).ToString) AND NOT String.IsNullOrEmpty(a.Field(Of String)(“Assignemnt”).ToString.Trim)).CopyToDatatable() Cheers @Anand_Designer

in Addition to [image] Palaniyappan: Hi Hope this expression would help you resolve this dt = dt.AsEnumerable().Where(Function(a) Isnumeric(a.Field(of String)(“Assignment”).ToString) Cheers @Anand_Designer Use a LINQ within assign activity left: Result | Datatype: List(Of Datarow) right…

Getting Error used DT As datatable variable [image]

You didn’t close after .ToString while checking Isnumeric Exactly here Check this expression again [image] Palaniyappan: dt = dt.AsEnumerable().Where(Function(a) Isnumeric(a.Field(of String)(“Assignment”).ToString) AND NOT String.IsNullOrEmpty(a.Field(Of String)(“Assignemnt”).ToString.Trim))…

have a look above on the detailed description

still getting error FilterAsiignment.xaml (6.9 KB)

@ppr Thank you for given a solution

Filter particular column only numeric and remove Empty row

Help Studio

ppr (Peter Preuss) October 12, 2021, 10:40am 9

find starter help:
FilterAsiignment_V2.xaml (8.3 KB)

Filter numeric values only using Filter Activity

Topic		Replies	Views
Excel Remove rows not numeric Studio studio , question , activities_panel	15	2316	October 7, 2021
Filter out empty rows Studio	3	69	July 16, 2024
Filter numeric values only using Filter Activity Activities excel , activities , question , filter	9	1312	December 18, 2023
Filter data table activity to remove empty rows Studio excel , studio , question , workflow_diff	7	583	January 26, 2024
Remove "NULL" word from excel Studio datatable , excel , studio	21	2277	September 29, 2021

Filter particular column only numeric and remove Empty row

Related topics