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