Filter numbers via filter data table

Help Activities
, ,
1

hi,

I need your help again.

I would like to filter data from an Excel file according to the country key. 3, 16 and 22 must be removed. In my example, however, 13, 32 etc. are also removed because 3 is present here.

How can I filter the numbers?

Thank you and best regards

Nina
image

image

2

Hi,

It seems strange behavior, because your operator is not “Contains” but “=”.
if possible, can you share your workflow and excel file as file?

Regards,

3

give a try on

Assign Activity:

dt_Steuerbetrag =

(From d in dt_Bruttobetrag.AsEnumerable
Where Not {"3","16","20"}.Any(Function (x) d(8).toString.Trim.Equals(x))
Select d).CopyToDataTable
1 Like
4

it works, thank you peter

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.