Merged with does not always work

Thanks! @keith

I never understood exactly why the solution of separating the two lists into custom states and then combining them did the trick for me but I suspected it had something to do with the order of the operations.

It does seem counter intuitive to me and I think @laurence is in the same boat so hopefully it’s helpful to the community to have a proper explanation.

I agree! This would be a great addition! Also, it would be great to have an operator to isolate the duplicates which could then be used for a filter to be able to completely exclude items that are the same in multiple lists. @fayewatson gave a good solution but didn’t think this was possible without touching the database. @neerja