Anaplan error - Error parsing key for this row; invalid data: , , ,

Shawnm · 2024-04-17T08:52:04+00:00

There was an error rendering this rich post.

Hi All,

When I am importing a file to a list I am getting an error as "Error parsing key for this row; invalid data: , , ," even though there is data in all the columns. Its a transaction data set that I am trying to import into a list with list properties using a combination of columns as unique identifiers.

It shows Error parsing key for this row; invalid data: , , , not sure why it is showing 3 comma's to the end of the error. Has anyone faces a similar issue?

Accepted answers

All comments

Dikshant

Can you share screenshot of import action and data that you are importing. Check in Import data source, what is the text delimiter you have set. Is it Comma or Tab>

Shawnm

Hi @Dikshant

Import properties are as follows, the default settings. The data is sensitive but it contains date fields, text fields and numeric fields. Since there is no unique identifier, I am using a combination of all fields. There 37 fields in total.

Dikshant

can you download the error logs and give some clue to understand better?

Shawnm

Hi @Dikshant , thanks for replying, as shown below this is the error for all the 62000 records I am trying to import. It says invalid data.

Dikshant

Is it possible for you to share the logs? Or check if your CSV file has extra blank columns.

Share screenshot for whole error log. Check which column is giving this error.

jagadishdash

@Shawnm TO address the exact issue, scroll to the full right and share the screenshot of the error column header or if comfortable share the .csv error log.

Shawnm

HI @jagadishdash & @Dikshant , this is the end of the error column, last column is the error shown but weird thing is that there are no comma's in any of the fields as shown in this screenshot.

I was able to sort it out at the source system end itself by adding a column as the primary key. Now it is not occuring.

jagadishdash

@Shawnm Okay, Great!

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…