Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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

 


 

1 Accepted Solution

Avatar

Correct answer by
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. 

View solution in original post

6 Replies

Avatar

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!

Avatar

Employee Advisor

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.

Avatar

Correct answer by
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. 

Avatar

Level 2

Actually I may have solved this.

I re created the file and uploaded this again and it seems to have worked....I started from scratch basically.

I am still unclear as to what the issue was but if I encounter this again I will follow the same course of action.

Many thanks again for your help! (This was my first community post)

Avatar

Level 4

You need a space between row 4 and 5.  I's always best to download the template file first, and then add your data.  Helps keep the gremlins out!

Avatar

Level 1
Level 1

This solution still has not worked for me