DB Row filter Wildcard

[sam020390]

Hello, I’m trying to filter to include rows that contain “,PP,” in a certain column. For example, row1 below contains that string but row2 does not. I’ve tried using the “LIKE” conditional but my table turns up empty.

row1: “B,C,D,E,G,GG,GN,L,LS,MC,P,PP,PS,SA,SH,XI”
row2: “A,B,D,L,P”

I’ve tried LIKE with the following strings and all of them give me an empty table:
“,PP,”
,PP,
“,PP,”
,PP,

I’m not sure how to do this. The rule-based row filter after the DB Reader node takes forever. Please help!

[sam020390]

I’ve also tried strings with asterisks before and after.

[ArjenEX]

Hi @sam020390

You should be able to just use a regular row filter node and look for *,PP,*. Make sure that the checkbox contains wild cards is enabled.

Example input:

Output:

[sam020390]

Thanks but I’m coming from the DB Column filter node and the row filter needs to go before the DB reader node. It won’t let me use the row filter or rule-based row filter nodes here.

[sam020390]

Thanks again for the help (!), I figured it out. I was using the * as the wildcard when I should’ve been using % in the DB Row filter.