Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
Hi,
you can use regular expressions, like here to flag rows based on the content of str:
Hi,
you can use regular expressions, like here to flag rows based on the content of str: