Forum Discussion
StoryofData
Helper III
Helper IIIM 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...
vicky_
Super User
Super Useryou can use "else if" in M.
StoryofDataHelper III
Helper IIIthink I got it!
if [EmplId] = ""
then ""
else if
[IemCity] = "Not Applicable"
or [IemCity] = "Not Disclosed"
then
""
else
[IemCaseNumber]&" | "&[EmplId]&" | "&[IemParticipantName]