Another row has already been processed with this key

Is there any way to suppress messages after importing into a List that are a result of the 'Another row has already been processed with this key'

Accepted answers

rlgarcia06

Hi! It seems you have multiple entries in the file with the same unique identifier. Ideally we need to edit the import file. But another work around is to load the data in a temporary list/module and create a validation module to clean up the data, and use a saved view of this validation module as source for the actual import to the target list/module.

All comments

JJANIK

I don't think you can simply disable warnings, but could you please advise why you need to do this?

BTW, If this is a result of building a list from the same source as data load (for example data contain periods causing key to be duplicated), a separate upload based on different source selecting unique items could help.

kmht0307

The reason for this is because when end users run a process containing several list import routines, when the confirmation message shows the warnings then they have to open each one to check if there are any errors and 99% of the time it is for the 'Another row has already been processed with this key' type message rather than a 'real' import error as such.

kmht0307

It is a building a list from the same source as data load type of thing, so maybe a unique items selection would be the best option.

rlgarcia06

kmht0307

Yes that is correct, it is a model that I have inherited and has been in use for some time. Basically there is one import process that pulls in data from the data hub model, this process updates several modules and lists in one process and on the lists it is set to only import the first instance of the list item, therefore we end up with a warning message each time. Usually the end user would ignore those messages but when we have new starters, they think that something has gone wrong with the import so just trying to eliminate that.

Quick Links

Can you help?

Unanswered questions

A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385