Data tables

You can use advanced scripting for email to design scripts to create a data table that displays a list of recipient-specific information in an email message.

In Deliver, to display a single piece of recipient data in an email, you add a personalization field to the email template. However, to display a list of related recipient-specific data, you must use a script that displays information that is provided from a dimension table in Unica Campaign. This list is referred to as a data table. The data table can contain a list of text values or links.

In a script, use the <@list> tag to specify the dimension table in Campaign and the specific fields in the dimension table that contain the information you want to display. Use the<@list> tag to sort and control how much information the script retrieves from the dimension tables.

The output of the <@list> tag appears as a list of values in the email. The script does not need to specify all of the fields that are contained in the dimension table, but you must map all dimension table fields that are specified in the script to the Output List Table (OLT).
Note: Changing the display name of the personalization field that is defined for the key field that connects a dimension table to a base table causes an error when you run the flowchart.

Deliver supports referencing multiple dimension tables in a single OLT. However, although you can configure multiple levels of dimension tables in Campaign, Deliver does not support using dimension tables that reference other dimension tables. Each dimension table that is referenced by a script must map directly to a base record table in Campaign.