Displaying data linked to Recipients in HTML table

[#1]

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-profil... but with Adobe Campaign Classic.

Email body to display data in below format

Item	Rate
Item 1	Rate 1
Item 2	Rate 2

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

[BFocus]

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 

[BFocus]

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.

[BFocus]

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.

[BFocus]

I cannot change rows into columns as my need is to display data with multiple rows and columns as a HTML table