In filter activity, starts with is not working

[anjani_priya]

In filter activity, starts with is not working.I have a data.I have used filter for filtering the data starts with 4 but its not working.

[ashokkarale]

@anjani_priya,

Not sure about the data you are using, but you can try LINQ also for this.

Thanks,
Ashok

[ppr (Peter Preuss)]

Give a try at:

Assign Activity
dtFiltered =

(From d in yourDTVar.AsEnumerable
Let sv =d("YourColNameOrIndex").toString.Trim
Where sv.StartsWith("4")
Select r =d).CopyToDataTable

[Ramya_25 (Ramya N)]

there may be difference in data type. check the data type and based on that give condition in filter activity

[anjani_priya]

the datatype is integers

[Ramya_25 (Ramya N)]

In filter activity give column name on left side, condition as starts with and in right side without double quotes give 4

[pravallikapaluri]

Hi @anjani_priya

Go to Manage Packages,Update the dependency of Excel activities to the higher version and make runtime rule as lowest to applicable version and save.

After that use Excel activities->FilterIt works for me

Hope it helps!!