How to Apply Finditem for Lists loaded with Combination of properties

anupgade

Hi All

Say I have a list A (Numb List) loaded thru combination of properties having item count of 10.

Then List B (Numb List) again loaded thru combination of properties having item count of 6

We cannot have code in both the lists.

I want to find items in List A which are matched in List B items, so as to delete them.

i.e 10-6 = 4 item should remain in List A

So is there any other way apart from Find item formula where we can match the items in both lists?

BenjaminNiel

Hi @anupgade,

First, keep in mind that list properties are quite bad for model performance and lists should be loaded through a unique code instead of combinations of properties.

https://community.anaplan.com/discussion/71178/1-05-03-avoid-using-list-properties

So, what I would recommend is to create, in the source file/module, a unique code based on the codes of the properties and use it as unique identifier in the import.

List 1:

List 2:

And as they are defined with the same properties, they should have similar codes. So, you can easily use finditem in the module.

Module:

With the function "ISNOTBLANK()", you can then find the duplicates.

Hope this helps!