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.