1

Can we check DE count based on specific field in same DE?

For Example : If Date= today()

If DE_Count > 1 
              set @Subject= "hello"
else
              set @Subject = "Thank You"

1 Answer 1

4

You can use LookupRows in combination with RowCount, like this:

set @today = Format(Now(),"yyyy-MM-dd")
set @rows = LookupRows("DataExtension","Date", @today)
set @rowCount = rowcount(@rows)

if @rowCount > 1 then
set @Subject= "Hello"
else
set @Subject = "Thank You"
endif

You must log in to answer this question.

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