Chrism Posted July 1 Share Posted July 1 Hi, I have a List in a field 'List A' and also a List in a field 'List B' I need a calculation field to filter the list so it only shows me the items from List A that are NOT in List B. I can do the opposite (show me items that are in both lists) easy enough using filtervalues. Any help appreciated. Thanks Link to comment Share on other sites More sharing options...
bcooney Posted July 1 Share Posted July 1 https://www.briandunning.com/cf/926 Link to comment Share on other sites More sharing options...
comment Posted July 1 Share Posted July 1 There are several possible solutions. Which one is best for you depends on how many values you expect to be in each list, and whether there can be duplicate values that need to be preserved. But basically these fall into 3 categories: 1. Loop over one of the lists (preferably the shorter one), testing each value in turn. This can be done using the While() function or by a custom function that calls itself recursively; 2. A non-recursive approach, such as shown here or here; 3. Using the (free) BaseElements plugin: https://docs.baseelementsplugin.com/article/542-bevaluesfilterout. 1 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted July 2 Share Posted July 2 22 hours ago, comment said: 2. A non-recursive approach, such as shown here or here; the last one of these👏 --sd Link to comment Share on other sites More sharing options...
Chrism Posted July 3 Author Share Posted July 3 Thanks all worked a treat Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now