0

i am trying to remove contacts of DE from receiving email which has a value in column named 'AffPersonPGUID' matching to the values present in a column by same name in DE named DE_ContactID using the below exclusion script

ROWCOUNT(LOOKUPROWS("DE_ContactID_Suppression", "AffPersonPGUID", AffPersonPGUID))> 0

the journey is not activating in which i have used this exclusion script in one of the emails, error being that AffPersonPGUID is an undefined variable.

1 Answer 1

1

I assume AffPersonPGUID exists as a field in your Event Source Data Extension? Please try the following:

ROWCOUNT(LOOKUPROWS("DE_ContactID_Suppression", "AffPersonPGUID", AttributeValue("AffPersonPGUID")))> 0
3
  • Hi @eliot thanks alot for the update, things worked. Just one more query can we use two exclusion using some or condition like ROWCOUNT(LOOKUPROWS("DE_ContactID_Suppression", "AffPersonPGUID", AttributeValue("AffPersonPGUID")))> 0 or RowCount(LookupRows("Global_and_Multi-Group","EmailAddress", emailaddr))>0 can we use it this way or some other thing needs to be done. Please Help Apr 25, 2017 at 3:53
  • I've never tried using an OR statement with two rowcount functions in an Exclusion Script, but I can't see why it would not work. Have you tried this? Apr 25, 2017 at 11:36
  • Yes i tried yesterday, things seems to be fine. doing second checks Apr 26, 2017 at 4:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .