Expand my Community achievements bar.

Pivot Table Format in ACS

Avatar

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

ID NAME GENDER AGE
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

Avatar

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