like operator supporting regular expressions

pnaik1

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.

fchataigner2

Hi,

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