RPL data directive evaluating blank

caseybraun

Hi, everyone.

I'm attempting to leverage the data directive in RPL to match a copy variant to subscribers based on a number assigned in a SQL view. My RPL looks like this:

<#data MySuppTable as variant><#filter SPLITNUMBER=VARIANTNUMBER><#fields SUBJECTLINE>${variant.SUBJECTLINE}</#data>

However, it keeps evaluating to a blank subject line even when I have verified the subscriber in question has a number assigned in the SQL view that matches the variant number.

Could someone perhaps let me know what I'm doing wrong?

Thank you so much!

Casey

racabu

I'm assuming the VARIANTNUMBER is in the contact list, right?

I would try using this:

<#filter SPLITNUMBER=CONTACTS_LIST.VARIANTNUMBER>