Forum Discussion

JoshuaRawe's avatar
JoshuaRawe
Qrew Trainee
7 years ago

QB says Not Unique; Excel and TextWrangler say Unique

I am attempting to add a table linked to a csv file in my Google Drive. The csv file has just two columns: Item, Cost. The Item is the unique ID used for Refresh and Key. When I refresh connection,...
Data import and export
Tables and fields
SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
7 years ago
I would delete the records in the quickbase table and try again. There may be duplicates in the Quickbase table.
  • JoshuaRawe's avatar
    JoshuaRawe
    Qrew Trainee
    7 years ago
    I deleted the QB table and my csv file from Google drive. I created a new table in QB and uploaded the same file linked in the problem. 

    I still get the "non-unique values" error.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Maybe import the data manually into a temporary Quick Base table and then make a summary report sorted by the # of records for that field in question.  See if there are any 2's.
  • JoshuaRawe's avatar
    JoshuaRawe
    Qrew Trainee
    7 years ago
    I created a temporary QB table and manually imported the file. There were no errors.

    I did find 1 duplicate. The reason it wasn't caught in Excel or TextWrangler was because there was a space in the cell after the duplicate value. :/

    Thank you for this quick and intelligent fix!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I figgered it was one of those leading or trailing space issues.