Filter non-matching records on list-join

[von Horst]

I created 2 lists A and B:
List A contains 3300 records
List B contains 28.000 records
I like to filter exactly those records that exist in List B but not in List A

What I did: created a join from List B to List A (based on one of the elements values)
Now how can I filter so I have a list showing only records existing in List B, but not in List A?
I also want to export this result as csv.

 

[cheesegrits]

I'm really not sure what you mean by "exist in list a but not list b". They are separate tables. None of the rows in B "exist" in A.

Do you mean rows in list A for which there is not a join element value in list B?

-- hugh

 

[von Horst]

yes exactly...I need those rows in List A for which there is not a join element in List B

 

[cheesegrits]

OK, so what have you tried so far by way of filters on that join? I think I added an IS NULL condition, so you could try a pre-filter which tests to see if the join element on the joined table is null.

-- hugh