How to use if statements to validate two strings

[moinyuso96]

I would like TestResult to give output "1" if there are "Pass" or "Completed" in Status and "0" if otherwise. How to change this query below to check for both strings?

| eval TestResult=if(like(Status, "%Completed%"), 1, 0)

[venkatasri · Accepted solution]

Hi @moinyuso96 

Can you try this,

| eval result=if(like(Status,"%Completed%") OR like(Status,"%Pass%"), 1 , 0 )

---

An upvote would be appreciated if this reply helps and Accept the solution!