Forum Discussion
Not statement within Conditional Column
Hey!
I have a campaign UTM that contains the what I need the same code which is PMAX and PLA. I am trying to seperate these and below is an Example what I am aiming for
PMAX= Campaign UTM Contains PMAX but NOT PLA
PLA= Campaign UTM contains PLA but NOT PMAX
I am trying a custom column with the below code but doesn't seem to be working
if Text.Contains([Campaign],"PMAX") <> Text.Contains([Campaign] ,"PLA") then "PMAX"
else "null"
Not sure where I am going wrong but any help is appreciated !
if Text.Contains([Campaign],"PMAX") and not Text.Contains([Campaign] ,"PLA") then "PMAX"
else if not Text.Contains([Campaign],"PMAX") and Text.Contains([Campaign] ,"PLA") then "PLA"
else "undefined"
3 Replies
if Text.Contains([Campaign],"PMAX") and not Text.Contains([Campaign] ,"PLA") then "PMAX"
else if not Text.Contains([Campaign],"PMAX") and Text.Contains([Campaign] ,"PLA") then "PLA"
else "undefined"
Hi Anonymous,
Just following up to check if the solution shared by our Super User lbendlin helped resolve your issue. If you're still facing difficulties or need further assistance, please let us know — we’re here to help!
If the response addressed your query, we kindly request you to mark it as Accepted Solution and click Yes if you found it helpful. This supports others in the community as well.
Best regards,
Prasanna Kumar
thanks lbendlin that worked!