Avoid creating duplicate items in list when importing from a versioned module
I have a process that creates keys and values in a list based on if a key has a non-zero value in a source module.
The source module is versioned and some key value pairs could be zero for some versions and non-zero for others. The list finally has to have all key value pairs that have non-zero values in at least one version.
Based on how the version module is set up, I am unable to write a filter (using RANK) to show only the first instance of the key because the filter resets for every version. Therefore multiple instances of the same key (depending on the number of versions) get loaded into the list. It gives a duplicate item message every time the action that does this is run.
Is there any way to avoid this message? The action says it has run with errors but it is not really an error as there are no failures.