Forum Discussion
Help with Data Model: Ambiguity between tables triggered_send and event
Hi everyone,
I am trying to get an active relationship established between triggered_send and event (together with send) following the Salesforce Marketing Cloud Schema here
It keeps prompting the same error despite renaming some of the fields. I am assuming the column names are still ambiguous?
I have also changed all the cross-filtering mode to single after going through the similar posts but still to no avail... I want to avoid using DAX as much as I can as this would be used by non data people.
Cheers!
Hi jervissho ,
As the error shows, you can't create direct active relationship between "email" and "send" . You can uncheck "make this relationship active", let the email and send tables be connected as an inactive relationship.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi,
This is because you have created 1 to * relationships between [List] - [Event] and [List] - [Triggered Send].
Two distinct paths are already specified for [List] to filter [Event] and [Triggered Send] tables.
So, if we try to make the [Triggered Send] - [Event] relationship active, it will create another indirect filter which will cause ambiguity in the data.
Due to this you cannot have another active relationship between [Triggered Send] and [Event] tables.
I am still faced with the same issue after deleting the rest of the links. I think the cause lies with email and event. Any chance i could make event reference to both triggered_send and send that is both needing to be reference from the email table?Hi jervissho ,
As the error shows, you can't create direct active relationship between "email" and "send" . You can uncheck "make this relationship active", let the email and send tables be connected as an inactive relationship.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
