How can we Pivot/unpivot the data sets in ACM

Question

for example suppose I have the sample data set as follows:-

email	segment	values
email1	segment1	value1
email1	segment2	value2
email1	segment3	value3

I want the result as follows:-

email	Seg1	Seg2	Seg3
email1	value1	value2	value3

Post this, we will use value1,value2,value3 in the email delivery as customization fields.

What is the better method to achieve this?

vraghav · Accepted Answer

Hi richac96395021 ,Yes this can be achieved,From the above setup, it seems that there are two schemas involved. One which contains email addresses and the other one which contains segment information. There is a one to many link between the two schemas.Use a query to fetch email and email1 records.Feed them to an Enrichment and select Data linked to the filtering dimension menu. It will then show you two options, this time select Data linked to the filtering dimension.Proceed through the wizard, select how many records per email you wish to fetch from segment schema.The output of this Enrichment will have the data in the format you need.Hope this helps.Regards,Vipul

richac96395021 · Answer

Thanks !! Vipul for the solution,can you suggest a solution for unpivotexample suppose I have the sample data set as follows:- emailSeg1Seg2Seg3email1value1value2value3I want the result as follows:-emailsegmentvaluesemail1segment1value1email1segment2value2email1segment3value3

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded