Using asterisks in dt.select comparison

Help
, ,
1

Hi, I have a code like this:
db_in.Select(“[VALUE] <> ‘ “ + var1 + ” ’“).CopyToDatatable()

Given that I have a list of numbers, let’s say 10000, 10001, 10002, 20001, 20002, 20003. I’d like to select only the variables that do not start with 2 (and 2 is defined in a variable). How do I go about changing my code? I’ve tried LIKE but been told that it’s text only (?) and either way I cannot get it working. Any tips?

2

Hi @mickeymack,
You can use filter data table activity here.

filterdtactivity
filterdtactivity1920×1080 161 KB
Filterdt.xaml (7.1 KB)

3

Unfortunately no, I cannot. This is just part of the code, I also use comparisons with variables containing multiple values, something that FDT doesn’t support.

4

Hi Mickeymack, we can add multiple conditions in row filter and have different operators. Please try else you need to write some custom code in your WF.

5

I have a variable named “Account” that contains five values. I cannot use Filter Data Table on this since there are no “IN” operator that works in Filter Data Table.

6

@mickeymack

Try this.

    db_in.Select("[ColumnName] NOT LIKE '2%'").CopyToDataTable