Classification upload error "First column is required to be the key" | Community
Skip to main content
dafhowells
Level 2
Aug 24, 2016 9:01 AM UTC
Solved

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

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

 


 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    dafhowellsAccepted solution
    Level 2
    Aug 25, 2016 8:20 AM UTC

    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 reply

    6 replies

    KristiB1
    KristiB1
    Level 4
    Aug 25, 2016 11:29 PM UTC

    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!

    Translate
    NL96_X
    New Participant
    Jan 21, 2022 9:05 AM UTC

    This solution still has not worked for me

    Translate
    dafhowellsAuthor
    Level 2
    Aug 25, 2016 9:55 AM UTC

    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)

    Translate
      dafhowellsAuthorAccepted solution
      Level 2
      Aug 25, 2016 8:20 AM UTC

      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. 

      Translate
        Hyder_Ziaee
        Hyder_Ziaee
        Employee
        Aug 25, 2016 3:52 AM UTC

        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.

        Translate
        KristiB1
        KristiB1
        Level 4
        Aug 25, 2016 3:31 AM UTC

        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!

        Translate
        Terms & ConditionsAccessibility statement

        Loading footer...