Hi,
Could you please explain what this error message implies? I believe that it is saying that it rejected the duplicated in that column of data that I loaded into the List, is this correct?
Thank you
As a starting point, you'd need to consider what makes each record unique in your data set.
Your data is likely unique to your org so it's hard to judge, but based on one of your screens, you'd potentially want to create a code field which joins the code component of 'Entity: Name' and 'Expense ID', as a starting point as they seem to be some form of identifier.
I can't see what other fields are in play and the two alone may not be enough but your goal is that each record should be uniquely identified. The exception is where you're loading data over time, into multiple versions, or the like.
Assuming you're using a numbered list, your 'Code' field is not unique and there's multiple records using that same 'Code'.
If you're using a non-numbered list and potentially, you're using 'Name' as your ID, the name you're using is also duplicated in your import file.
Ignored records could be multiple things such as blank rows being loaded (depending on file type used) or you're loading in records which are only applicable at a summary level (such as nodes or aggregates).
ok, thank you for your response. What would be the best way to fix this error load?
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
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.…
