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?
Hi, I'm using the OFFSET formula, where a calculated and number-formatted field determines how many previous weeks the formula should look back. Based on this value, it retrieves the corresponding week's data into the output line item. The formula works correctly for some products; however, it fails for others. The issue…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.
