Forum Discussion
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...
you can use "else if" in M.
think I got it!
if [EmplId] = ""
then ""
else if
[IemCity] = "Not Applicable"
or [IemCity] = "Not Disclosed"
then
""
else
[IemCaseNumber]&" | "&[EmplId]&" | "&[IemParticipantName]