- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi @andregonzalez
I confirm what Deb is stating but if could express a bit more what you mean by "filter my recipient from 3 different schemas": what is exactly your need?
You could first use a query activity on schema nmsRecipient: you'll be able to query on recipient but also on broadlogs like this:
in the query editor double click on the orange link "recipient delivery logs" > you'll get automatically in the expression a sub query starting by "recipient delivery logs exist such as" and you can change the operator to "does not exist such as" / "exists" / "does not exist". You then can select every attribute you want
This way, a single query activity could permit you to filter 2 schema from your example.