IF contains multiple conditions

Options
yesitsmeoffical
yesitsmeoffical Registered Posts: 15
edited July 16 in Using Dataiku
col
A
B
3
10
if(contains(toUppercase(col),"A"),"letters",
if(contains(toUppercase(col),"B"),"letters",
"others"))

The code above works but is it possible to shorten it to combine the logic for "A" and "B"?

For example in the syntax below (albeit incorrect):

if(contains(toUppercase(col),"A" or "B"),"letters",
"others")

Best Answer

Setup Info
    Tags
      Help me…