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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Join us for our next ☕Adobe Campaign Community Q&A Coffee Break☕, on Thursday, February 9th @ 9.30 am IST & 9 am PT
SOLVED

Calculate touchpoints

Avatar

Level 2

Hi all,

 

In a workflow, we want to get the touchpoints of each profile to insert in a custom resource that we have created. We have tried creating a additional field in a query acivity, counting the delivery logs, with the following function "Count(logs)", but we get the following error "PGS-220000 PostgreSQL error: ERROR: INSERT has more target columns than expressions"

 

Do you know how can we do it?

 

Thanks

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @LAR1985,

 

Try with type aggregate on additional data in query activity to count the deliveries received.

SatheeskannaK_0-1671029419865.png

SatheeskannaK_1-1671029446169.png

SatheeskannaK_2-1671029461167.png

Result:

SatheeskannaK_3-1671029535031.png

 

Thanks!

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @LAR1985,

 

Try with type aggregate on additional data in query activity to count the deliveries received.

SatheeskannaK_0-1671029419865.png

SatheeskannaK_1-1671029446169.png

SatheeskannaK_2-1671029461167.png

Result:

SatheeskannaK_3-1671029535031.png

 

Thanks!