like operator supporting regular expressions
pnaik1
Registered Posts: 23 ✭✭✭✭
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.
Best Answer
-
Hi,
you can use regular expressions, like here to flag rows based on the content of str: