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 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!