Unable to add join condition in Edit Schema in Campai...

[iyerdeepa]

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

[_Manoj_Kumar_]

Hello @iyerdeepa 

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

[iyerdeepa]

Thank you Manoj!

[Jyoti_Yadav · Accepted solution]

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.

[iyerdeepa]

Thank You!!