Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Transpose data adobe campaign classic

Avatar

Avatar
Level 1
Chinni
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
Chinni
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
Chinni
Level 1

15-08-2020

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 

 

PartyIdMonthMoney_arrears
123Jan20
123Feb27
123Mar45

 

I am looking for transposing the data into something like

 

PartyIdMonth_JanMonth_FebMonth_March
123202745

 

Many Thanks

Chinni

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 1
Level 1
taplondon_josh
Level 1

Likes

2 likes

Total Posts

7 posts

Correct Reply

2 solutions
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Level 1
taplondon_josh
Level 1

Likes

2 likes

Total Posts

7 posts

Correct Reply

2 solutions
Top badges earned
Boost 1
Affirm 1
View profile
taplondon_josh
Level 1

18-08-2020

Hi @Chinni ,

 

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

 

taplondon_josh_0-1597766092246.png

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.)

 

taplondon_josh_1-1597766425419.png

 

Thanks,

 

Josh

Answers (1)

Answers (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

161 likes

Total Posts

380 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

161 likes

Total Posts

380 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

16-08-2020

Hi @Chinni

try to explore posibilities of Change dimension node in AC.

Check this similar example: Pivot and unpivot functions 

Regards,

Milan