Unable to add join condition in Edit Schema in Campaign Classic

Avatar

Avatar

iyerdeepa

Avatar

iyerdeepa

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

View Entire Topic

Avatar

Avatar

Jyoti_Y

MVP

Avatar

Jyoti_Y

MVP

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.