Filtering data not giving proper output

[Sirisha_Siri]

Hi,

I am trying to do remove rows that contains “Transfer” in column name “Capability”, similarly i am applying other filters as shown below. but filtering is not being done. Can some one help. After filtering data to new excel again i can see rows with “transfer”. Please correct me if i am missing anything. Workflow attached for reference.

Testfilter.xaml (13.9 KB)

[ashwin.ashok ((TheCodingTheory))]

Hi @Sirisha_Siri ,

Could you toggle the options over to OR?

Kind Regards,
Ashwin A.K

[nikhil.girish]

Hi @Sirisha_Siri

since you have AND operator even though you want to eliminate “Transfer” tht is not happening

can u try using one separate filter activity for “Transfer” just fr ur testing , but eventually “OR” works fr you

“AND” works something like this

lets say you want to delete “AB” AND “BC”

so AND will be expecting both to be present , so u may say BC was not present but still “AB” dint delete /…thts how AND works…so kindly go with “OR”

[Gokul001 (Gokul Balaji)]

Hi @Sirisha_Siri

Can you change the option to OR

Instead of = change it into Contains

In the above syntax :

Column Name Capability Equal Transfer And Device / Accessories Equal SIM

And Operator-> Use to check more than one condition before performing an activity

Regards
Gokul

[Palaniyappan (Palaniyappan P)]

I think you are almost done
Try mentioning as contains instead of = for the filter set to column “Capability”

It should be working fine and the reason might because of some extra space along the word Transfer

Or

If that doesn’t work either let’s do it with a simple assign activity like this

dt = dt.Asenumerable().Where(Function(a) a.Field(of String)(“Capability”).ToString.Trim.Contains(“Transfer”) AND a.Field(of String)(“Warehouse Recon…”).ToString.Trim.Contains(“NA”) AND a.Field(of String)(“Device / Accessories”).ToString.Trim.Contains(“SIM”) AND a.Field(of String)(“Device / Accessories”).ToString.Trim.Contains(“Service”) AND a.Field(of String)(“Recon Creation….”).ToString.Trim.Contains(mondate) ).CopyToDatatable

Cheers @Sirisha_Siri