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: 1,947 NeuronIt'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().