Displaying data linked to Recipients in HTML table | Community
Skip to main content
B
BFocus
July 27, 2020
Question

Displaying data linked to Recipients in HTML table

  • July 27, 2020
  • 2 replies
  • 1815 views

How to display data linked to a profile or recipient as multiple rows in a email delivery. This requirement is something similar to this post https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/using-data-linked-to-profiles-in-an-email-delivery-including/qaq-p/372204 but with Adobe Campaign Classic.

 

Email body to display data in below format

 

ItemRate
Item 1Rate 1
Item 2Rate 2

 

ItemItemItemRate
ItemA 1ItemB 1ItemC 1X Rate 1
ItemA 2ItemB 2ItemC 2X Rate 2
ItemA 3ItemB 3ItemC 3X Rate 3

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Jyoti_Yadav
Jyoti_Yadav
Level 8
July 28, 2020

Hi,

 

You can store data as List in one variable and then use JS in email to display them as desired.

Logic will be: Change rows in column so that there will be one row with respect to each profile/recipient.

Then use those columns in your Email.

Let me know if you need more help for building it.

 

Thanks.

B
BFocusAuthor
July 28, 2020
I cannot change rows into columns as my need is to display data with multiple rows and columns as a HTML table
M
mak_007
July 30, 2020

You can display them by selecting variables in delivery and iterate over them using for loop to print those results .

 

 

Let me know if  you need more help.

 

Regards

AM 

B
BFocusAuthor
August 6, 2020
Can you elaborate in my case it will be Parent table P and Child table C1 and C2 & C3. For every record in P there will X records in C1, Y records in C2 & Z records in C3,. How do I prepare this data in my workflow and bring it to the delivery template and iterate in a for loop.
Terms & ConditionsAccessibility statement

Loading footer...