Testing an Exclusion Script using AmpScript

Question

I'm trying to test if an exclusion script works in journey builder using a script like this:

ROWCOUNT(LOOKUPROWS("my-data-extension","EmailAddress", EMAILADDR))>0

How could I use the script in a test email in email studio, and modify the code to print the result of the Script? Such as, if the Ampscript code returns "1" during the preview and test with the respective data extension, it would exclude the subscriber.

Could someone help me figure out how to write the AMPscript using the V function?

Answer 1

You can just do something like this to output the results of the rowcount:

%%[

var @rc
set @rc = ROWCOUNT(LOOKUPROWS("my-data-extension","EmailAddress", EMAILADDR))

if @rc > 0 then
  output(concat("<br>excluded"))
else
  output(concat("<br>sent"))
endif

]%%