How can we Pivot/unpivot the data sets in ACM

[richac96395021]

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?

[Vipul_Raghav · Accepted solution]

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.

1. Use a query to fetch email and email1 records.
2. 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.
3. Proceed through the wizard, select how many records per email you wish to fetch from segment schema.
4. The output of this Enrichment will have the data in the format you need.

Hope this helps.

Regards,

Vipul

[richac96395021]

Thanks !! Vipul for the solution,

can you suggest a solution for unpivot

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

email Seg1 Seg2 Seg3 email1 value1 value2 value3

I want the result as follows:-

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

[Vipul_Raghav]

You can make use of Change Dimension activity.