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?
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…
