Unable to add join condition in Edit Schema in Campaign Classic | Community
Skip to main content
I
iyerdeepa
June 9, 2020
Solved

Unable to add join condition in Edit Schema in Campaign Classic

  • June 9, 2020
  • 2 replies
  • 2568 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jyoti_Yadav

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.

 

2 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
June 9, 2020

Hello @iyerdeepa 

 

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

Manoj  | https://themartech.pro
    I
    iyerdeepaAuthor
    June 10, 2020
    Thank you Manoj!
    Jyoti_Yadav
    Jyoti_YadavAccepted solution
    Level 8
    June 10, 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.

     

      I
      iyerdeepaAuthor
      June 10, 2020
      Thank You!!
      Terms & ConditionsAccessibility statement

      Loading footer...