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 C...
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"
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"