When to use In/Not in Results instead of adding the Data Extension to my Selected Data Extensions?

sometimes you might want to filter using data from a data extension that you do not want to add to your selected data extensions let's see an example to understand why this could be the case suppose you have an orders data extension and a customers data extension with the records shown below orders id customerid 1 1 2 1 3 2 customers id email 1 john\@gmail com 2 lisa\@gmail com because the customerid column in the orders data extension is not unique when you try to join those two data extensions, the result would look like this orders with customers orderid customerid email 1 1 john\@gmail com 2 1 john\@gmail com 3 2 lisa\@gmail com because there is a one to many relationship between those two tables duplicate values on the email column show up depending on the use case, the email duplicate values that show up might be unwanted to avoid such a scenario it is recommended, when possible, to use in/not in results filter instead of adding to your selected data extensions to sum up add to ‘selected data extensions’ in / not in results when you need a field of a data extension to populate a target data extension field when you do not want duplicate rows when you want to use a data extension that is not in your ‘selected data extensions’