Classification upload error "First column is required to be the key"

Forum|Forum|9 years ago
August 24, 2016
5 replies
4037 views

Hi, I hope someone can help me,

I am attempting to import a classification file and every time I try I get the following error message:

"First column is required to be the key"

The first column in my file is indeed the key so I don't understand what the issue is. I recall having this problem before and removing duplicated rows seemed to do the trick but I am at a loss here.

Can anyone suggest a solution?

Thanks
Daf

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by dafhowells

Many thanks to both of you for your responses.

I have tried deleting any empty columns above and below the data but when I tried uploading the file again I got the same result.

Attached is a screenshot of the top of the file. The variable is v74 and the the values in the key column are correct.

KristiB1

Level 4

HI Daf - are you able to screen shot your upload file, as well as give details of what variable you are uploading against. this will be the quickest way for the community to help!

Hyder_Ziaee

Adobe Employee

Some of the things that I would check for are:

Are there any spaces below the data?
Are there any spaces to the right of the data?

For this, you can simply open the file in excel and select all the empty columns to the right of your data and then press delete. Similarly select all rows below your data block and press delete.

D

dafhowellsAuthorAccepted solution

Level 2

Many thanks to both of you for your responses.

I have tried deleting any empty columns above and below the data but when I tried uploading the file again I got the same result.

Attached is a screenshot of the top of the file. The variable is v74 and the the values in the key column are correct.