Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Join us for our next Adobe Campaign Community Q&A Coffee Break, on Thursday, February 9th @ 9.30 am IST & 9 am PT

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