Unable to add join condition in Edit Schema in Campaign Classic

Avatar

Avatar
Validate 1
Level 1
iyerdeepa
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
iyerdeepa
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
iyerdeepa
Level 1

09-06-2020

Hi All,

 

I have a requirements to calculate some aggregates and combine that with my original dateset. I am using the Edit Schema step to accomplish that.

 

However when defining the Link, and underlying join condition, I get an error when I try to pick the destination field from my temporary schema I get an error that graphical component PathEdit has thrown an error.

 

Can someone please advise on what can be done?

 

Thank You,

Deepa

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

89 likes

Total Posts

123 posts

Correct reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

89 likes

Total Posts

123 posts

Correct reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile
Jyoti_Y
MVP

09-06-2020

Hi Deepa,

You are getting error because your query is now having new schema, it has no value present of previous activities.

You can perform your operation by two ways:

1) Take two query condition, one where you will do aggregation and second where you will query on your schema. Then perform union/intersection based on your requirement.

2) First perform aggregate and then use enrichment to enrich with your schema.

 

Thanks.

 

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

126 likes

Total Posts

329 posts

Correct reply

103 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

126 likes

Total Posts

329 posts

Correct reply

103 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile
_Manoj_Kumar
MVP

09-06-2020

Hello @iyerdeepa 

 

Instead of Using the Edit schema, You can use the enrichment and then add the aggregated results in the additional data.