I am assisting with a MC project and am having conceptual issues with platform when it comes to exclusion scripts.
When in a Journey and you have a "Send Email" action open there is a "Exclusion Script" text input for excluding records.
The script I want to exclude is pretty straight forward
(NOT(ISNULL(EXPDAT)) && EXPDAT <= NOW()) || Comm_Preferences == "No" || (NOT(ISNULL(DSS_End)) && DSS_End <= NOW())
When I Activate the Journey I get an error
ISNULL(EXPDAT) Attribute or Field Name: EXPDAT Invalid Content
I also have this script saved as a DataExtension and saw a post about linking the data extension to the email action, but I'm not understanding how that "link" works.
(ROWCOUNT(LOOKUPROWS("ExclusionDE", "EmailAddress", Email_Address)) > 1)
I've never worked on MC and appreciate any advice.