like operator supporting regular expressions

Solved!
pnaik1
Level 3
like operator supporting regular expressions

I can't find a way to implement following SQL where clause in Dataiku Prepare recipe (using Formula Processor):

(table1.col1 Like "*D0*") OR (table1.col2 Like "*D*0")

seems like processor doesn't support * or %. I tried "find and replace" processor too but didn't work (also it doesn't work for else condition). So I want to populate a new column with Yes if above conditions met otherwise with No. 

Thanks.

0 Kudos
1 Solution
fchataigner2
Dataiker

Hi,

you can use regular expressions, like here to flag rows based on the content of str:

Screenshot 2021-06-25 at 14.42.37.png

View solution in original post

0 Kudos
1 Reply
fchataigner2
Dataiker

Hi,

you can use regular expressions, like here to flag rows based on the content of str:

Screenshot 2021-06-25 at 14.42.37.png

0 Kudos