Skip to main content
Question

QB says Not Unique; Excel and TextWrangler say Unique

  • December 7, 2018
  • 0 replies
  • 56 views

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, I get "The error was: The source data includes non-unique key values, the column value(s) from the source query that correspond to the destination key column(s) must be unique."

I have tried removing duplicates in Excel and it says no duplicates. I have made sure there are no additional blank rows at the end of the csv. I have formatted the Item column as Text in Excel before saving down to csv.

I have opened the csv file in TextWrangler and searched for duplicates and found none.

And yet, QB says non-unique values exist in this column every time.

CSV file here.
This topic has been closed for replies.

  • Registered
  • December 7, 2018
I would delete the records in the quickbase table and try again. There may be duplicates in the Quickbase table.