Customized Report in Adobe Campaign

Avatar

Avatar
Boost 1
Level 1
vivekraob838618
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
vivekraob838618
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
vivekraob838618
Level 1

23-08-2018

I am trying to develop customized report in adobe campaign from Configuration menu. As I need several tables in single report I have written 5-6 query boxes in the report. Each Table in report access the data from respective query box. I need help for two things:

1) Fetching data from different queries in for same table.

I want data from two different queries in single table.

2) Changing the variable name and reassign in report.

I am querying for one of the column in workflow but I want to reassign the value and print it in table.

For eg. If column value is customer_twoWheeler_day1 I want it to only print Two Wheeler in report column.

PFB the workflow I used.

wf.JPG

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
Garima_Gakhar
Employee

23-08-2018

Hi vivekraob83861863

Please find below response from my side:

1) In order to store data from multiple queries into one table, you will have to create your own customized Schema to be able to store values into that.

The Schema should then be taking into account all fields coming from two (or more) Query Activities.

All this is stored within a temporary table though, but that's not a good practice.

Firstly, that storage is secondary. Secondly, it consumes a lot of database space.

2) In order to change the variable name and reassign it within a Report, you could try incorporating Substring function () and defining the length of the string to be picked up.

Hope that helps!

Answers (2)

Answers (2)

Avatar

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
Garima_Gakhar
Employee

29-08-2018

Not sure vivekraob83861863​, if Cube would prove to be that helpful.

Avatar

Avatar
Boost 1
Level 1
vivekraob838618
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
vivekraob838618
Level 1

Like

1 like

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
vivekraob838618
Level 1

24-08-2018

Can Cube will be used for this requirement for better results?