Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!

Pivot Table Format in ACS


Level 3

Hi Everyone,

Hope you all are doing well.

I have sample data in following format in single schema: 

ID Attribute values
ID1 NAME value1
ID1 GENDER value2
ID1 AGE value3
ID2 NAME value4
ID2 GENDER value5
ID2 AGE value6


I want the result as follows to store it in some other schema

ID1 value1 value2 value3
ID2 value4 value5 value6


Once the data is formatted in Pivot table , we want to utilize the values present in NAME,GENDER,AGE fields in the email delivery for personalization purpose.


Kindly suggest the way to achieve it in ACS ?


Thanks and Regards,

Neelam Bakre

1 Reply


Employee Advisor

1 potential way:

  • Use a fork to split it into 2 branches
  • On one branch, use a deduplication on the ID field
  • Afterwards use an enrichment
    • Main set = result of deduplication
    • Then add 1 join for each of the needed fields
    • Sample Condition: ID=ID && Attribute=Name
  • Then you should be able to use it in the mail content