like operator supporting regular expressions

pnaik1
pnaik1 Registered Posts: 23 ✭✭✭✭
edited July 16 in Using Dataiku

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

Setup Info
    Tags
      Help me…