Forum Discussion

EricC's avatar
EricC
Frequent Visitor
8 years ago
Solved

IF or Switch Function, Multiple Criteria

Hey All, I have "short description" column that list the descriptions of support tickets. I would like to create a new column based on a word or words that appear in the short description. 

 

For example 

Short_Description

Issues with Monitor

Issues with Display

 

 

New column would return the word "Monitor" for any row that contains the words "Monitor" or "Display".

 

Now I can get this working with one specific word as follows:

 

if Text.Contains([short_description], "Monitor") then "Monitor" else "0")

 

I just am struggling getting it to work with mutiple words/ text values.

 

Thank you!

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    EricC,

    Add a custom column using the following code.

    if Text.Contains([short_description], "Monitor") 
then "Monitor" 
else if 
Text.Contains([short_description], "Display") 
then "Display" else "0"



    Regards,
    Lydia

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    EricC,

    Add a custom column using the following code.

    if Text.Contains([short_description], "Monitor") 
then "Monitor" 
else if 
Text.Contains([short_description], "Display") 
then "Display" else "0"



    Regards,
    Lydia