Forum Discussion

Tobias2019's avatar
Tobias2019
Regular Visitor
6 years ago
Solved

If - else function with two Text.Contains functions combined with "and"

Dear all,   I try to achieve a combination of Text.Contain statements, but I fail with that. I don't know where to look at, maybe you do have an idea.   I have got following structure in my table...
Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    Tobias2019 

     

    I was able to create a new column for the specified condition with final else condition. Make sure to use the correct column names.

     

     

    Let us know if this helps.

Tobias2019's avatar
Tobias2019
Regular Visitor
6 years ago

Hello together,

 

I managed to solve the issue.

The statement of VasTg is correct!

In my special case, I had a formatting issue in the column, which I used for the second statement (Interface name). Although I used the Text.Contains function and only searched to a small part of the text, the query brought up errors.

Now I used another column containing similar information and here it works.

 

Anyone else having the same problem: Use the query how VasTg buildt it. If you fail, first try to use another column to check, if the query is the problem or your data format.

 

Topic solved!

 

Thanks & regards,

Tobias