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

Shawnm

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?

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!