I'm trying to update a list hierarchy from a module, which I have updated with an import file, and everything seems to be working just fine, that is, my list items are updated. However, since I have the same list item occurring several times in my import file, and also in the module I import from, I get the error message "Another row has already been processed with this key" and then the yellow warning triangle.
Does anyone know how to avoid this? I don't want my client to think that there is an error in the import when it actually worked just fine.
Re: Error when updating hierarchies with list items
Thanks a lot for your reply. However, I'm not sure if this would work for me, since I am trying to update 5 lists from one module, and as far as I understand, ISFIRSTOCCURRENCE can only be used when you have the list you want to update as dimension. Or am I wrong?
The IsFirstOccurrence() function works on the list within the source module, not the target list. For example, you have a transaction module using Trans List as your list, but you want to find the first occurrence of a line item (Product) to be used in several lists downstream. The formula would be isfirstoccurrence(Product, Trans List) which can be used as a filter for your other views.