Transpose data adobe campaign classic

[#1]

Hi All,

Can you please help me in finding a way to transpose the data from different columns into a single for a customer. I am using adobe campaign V7 

PartyId	Month	Money_arrears
123	Jan	20
123	Feb	27
123	Mar	45

I am looking for transposing the data into something like

PartyId	Month_Jan	Month_Feb	Month_March
123	20	27	45

Many Thanks

Chinni

[#2 · Accepted solution]

Hi @Chinni ,

Using a query activity in a workflow, leave the filtering conditions blank and configure the output columns to look something like this:

The records outputted will be grouped by partyId, and the newly month colums will sum the Money_arrears values for each partyId, but only if the month is equal to the one you specify. (Remember to disable automatic adding of primary key in the query's advanced parameters.)

Thanks,

Josh

[#3]

Hi @Chinni

try to explore posibilities of Change dimension node in AC.

Check this similar example: Pivot and unpivot functions 

Regards,

Milan