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 potential way:Use a fork to split it into 2 branchesOn one branch, use a deduplication on the ID fieldAfterwards use an enrichmentMain set = result of deduplicationThen add 1 join for each of the needed fieldsSample Condition: ID=ID && Attribute=NameThen you should be able to use it in the mail content

N

NeelamBakre

Level 3

Question

Pivot Table Format in ACS

Forum|Forum|3 years ago
August 2, 2022
1 reply
839 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

B

bisswang

Adobe Employee

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded