Two columns mapped error sadams7703  2018-12-17 09:35
Status: Closed

When I try to upload datasets I get an error message "Two columns mapped to target column: ptid_full".
I am not sure why this is. "ptid_full" is the subject ID as defined in the Study Properties.
There is a second column in the Excel sheet named "ptid" as you can see in the screen shot. Deleting this column in Excel fixes the problem, but I don't understand why LabKey is trying to map two columns instead of only the "ptid_full" column.

Additional finding-- renaming the column "ptid" to "ptidnum" in Excel (instead of deleting) also allows upload.

Jon (LabKey Support) responded:  2018-12-17 23:10
Hi Scott,

Would it be possible for you to send us an example of one of your files you tried to upload where it triggered the error?

Please feel free to sanitize the information in the file. We're mainly interested in the columns you have.

Also, just to confirm, this is a visit-based study, correct?