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

[#1]

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

[iyerdeepa · 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 · Accepted solution]

Thank You!!