List A vs List B

[Chrism]

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

[bcooney]

https://www.briandunning.com/cf/926

[comment]

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.

 

[Søren Dyhr]

22 hours ago, comment said:

2. A non-recursive approach, such as shown here or here;

the last one of these👏

--sd

[Chrism]

Thanks all worked a treat