You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to pull in values from second sup table

Received Response
11
Views
3
Comments

Hi all,

I'm unable to pull in data from fields within a second supplemental table - and the data is not even showing in the data output section of the campaign preview.

I have a sup table of bookings, which links back to the list on email address. This in turn needs to pull data from a products table, which uses the PRODUCT_CODE field to link back to the bookings table. My RPL looks like this:

<#data BOOKING as booking>

     <#filter EMAIL_ADDRESS_1 = CONTACTS_LIST.EMAIL_ADDRESS_>

     <#fields PRODUCT_CODE ENCODED_PARAMETERS BOOKING_NAME>

          <#data PRODUCTS as products>

               <#filter PR_PRODUCT_CODE = booking.PRODUCT_CODE>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!