Forum Discussion

StoryofData's avatar
StoryofData
Icon for Helper III rankHelper III
3 years ago

M Launguage If Statement

How do I add another condition to this?   if [EmplId] <> "" then [IemCaseNumber]&" | "&[EmplId]&" | "&[IemParticipantName] else ""   I need it to do a custom column of [IemCaseNumber]&" | "&[E...
Need Help
Tutorial Requests
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

you can use "else if" in M.

  • StoryofData's avatar
    StoryofData
    Icon for Helper III rankHelper III
    3 years ago

    think I got it!

    if [EmplId] = ""
    then ""

    else if
    [IemCity] = "Not Applicable"
    or [IemCity] = "Not Disclosed"
    then
    ""

    else
    [IemCaseNumber]&" | "&[EmplId]&" | "&[IemParticipantName]