Unable to add join condition in Edit Schema in Campaign Classic

iyerdeepa

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)

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)

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