Forum Discussion

mshodge's avatar
mshodge
Frequent Visitor
9 years ago
Solved

Multiple Column Criteria for Nested IF

Folks, there must be a better way than this IF statement which works but is just ugly. My rows represent an operator maintenance inspection which includes 16 columns each which represents a specific ...
Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    not sure but i think it will work:

     

    myvalue = if(col1 = "Issue" || col2 = "Issue" || col3 = "Issue" || col4 = "Issue", "Issue", "Not Issue")

     

    Basicaly you can have multiple fields in OR

parry2k's avatar
parry2k
Super User
9 years ago

not sure but i think it will work:

 

myvalue = if(col1 = "Issue" || col2 = "Issue" || col3 = "Issue" || col4 = "Issue", "Issue", "Not Issue")

 

Basicaly you can have multiple fields in OR

ImkeF's avatar
ImkeF
Community Champion
9 years ago

You can add a column in the query-editor with this formula:

if List.Contains(Record.FieldValues(_), "*ISSUE*") = true then "*ISSUE*" else "CHECKED"

Record.FieldValues(_) will transform the current row into a list and

List.Contains will check if your keyword is contained.