Pivot Table Format in ACS

[NeelamBakre]

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

[NeelamBakre]

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

[ramon_bisswanger]

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