3

When building a filtered data extension X, based on a data extension A with data relationships (A to B and B to C). We can easily filter A on a field in B. We can also filter B on a field in C. We can also see fields in C, when filtering A. But using them as conditions in our filter, always returns 0 rows. Even though we can repeat same filtering using a query, and get a number of rows returned.

Shouldn't this be possible? We have contacted SFMC support, and can't get a clear answer back from them.

4
  • 1
    Why use Filters and Relationships? A Query Activity would be a better (and more explicit) option -- especially since you're using Data Extensions. Jan 30, 2017 at 14:24
  • Point taken - and this would also be my preferred approach. However, I am building this solution for a client, and they would prefer using filters, since this is more intuitive than queries. Jan 30, 2017 at 15:51
  • It was a documented feature (help.salesforce.com/…) - wonder if it somehow lost functionality with the 'Enhanced' update? Sep 4, 2019 at 14:57
  • I would also have expected it to work as per documentation. However my few attempts so far have been fruitless. Sep 4, 2019 at 15:03

1 Answer 1

2

This may seem anecdotal but I have seen on more than one occasion that Marketing Cloud has a very hard time with multiple exclusions and every time I split it apart to filter one thing at a time, it manages to do it better. I will mention I've seen this happen more frequently with Queries than with Filtered DE's but the same logic looks like it applies. Can you try spreading them out?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.