#Sales Cloud #Marketing Cloud #Analytics #Trailhead
Hello, I am trying to add a logic in transform node using a case statement. My aim is to create this logic - (Option 1 OR (Option 2 AND Option 3))
Option 1 = Campaign Type excludes "X, Y, Z"
Option 2 = Campaign Type equal to "X, Y, Z"
Option 3 = Meeting booked equals "True"
While I try to add this case statement, it gives the attached error message. Below is my statement -
case when ("Campaign.Campaign_Type" not in ['X', 'Y', 'Z'] or ("Campaign.Campaign_Type" in ['X', 'Y', 'Z'] and 'CFCR_Meeting_Booked__c' == "true") then LeadtId else null end
@Ravi Deshmukh case when C.CType ! = 'COD' || C.Ctype != 'IData' || C.Ctype != 'MM' || c.ctype is null
|| when C.CType = 'COD' && CFR = 'trur' || C.Ctype = 'IData' && CFR = 'trur' || C.Ctype = 'MM' && CFR = 'trur' then LeadContID else null end
Note- please don't give any quote to field name , and give single quotes to text value.
Sorry IN clause is not supported in recipe/dataprep
Make sure the Output type is TEXT
