LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Multiple IF

    Employee
    Posted 11-05-2015 20:21

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: jchartrand

    Looking to perform a "Multiple IF" ... been trying and searching for an answer. Hoping someone can help.

    if 'Field1' == "25713" or "65101" or "65108" or "65111" then WorkflowException = "Y" else WorkflowException = "N"

    This is what I have now... I have used many "if then else" statements" but never one with multiple conditions.

    Any help would be great!

    J


  • 2.  RE: Multiple IF

    Employee
    Posted 11-05-2015 20:28

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: jchartrand

    Roger Yeh is amazing and got back to my email at 10:30PM

    To anyone that is looking for an answer...

    You need to rewrite 'Field 1' for each condition.

    if 'Field1' == "x" or 'Field1' == "y" or 'Field1' == "z"


  • 3.  RE: Multiple IF

    Employee
    Posted 11-05-2015 20:58

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    Well, Josh, you're the one asking questions at 10:30pm!

    For those interested, if the list of values you're checking against is pretty long, it may look better to put it all in a 'list' and then use the 'find' function to see if Field1 matches any items. See attached.
    Attachments:
    findList.brg