IF contains multiple conditions
yesitsmeoffical
Registered Posts: 15 ✭
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
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,063 Neuron
It's possible but not going to help you simplify the expression. Using the boolean operators:
if(contains(toUppercase("ABC"),"D") || contains(toUppercase("ABC"),"A"), "letters", "others")
Or using boolean functions:
if(or(contains(toUppercase("ABC"),"D"), contains(toUppercase("ABC"),"A")), "letters", "others")
You will be better using match() with a regular expression and check the output with length().