Forum Discussion

DarylM's avatar
DarylM
Icon for Helper II rankHelper II
9 years ago
Solved

Can't create a relationship between two columns

Hi, I am having trouble creating a relationship betwene two tables.  One table has a unique customer number and name along with customer details like address, phone, etc.  The other table with sale...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Somehow you must have ended up with at least one duplicate in the customer table. You can either use the Remove Duplicates option in the query editor, or perhaps you can hunt down the duplicate and fix it at the source. The easiest way to find the duplicate is to create a measure to count the customer ID column, then drop that column and that measure on a table visual, sort by the measure and see which ones come up more than 1.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Somehow you must have ended up with at least one duplicate in the customer table. You can either use the Remove Duplicates option in the query editor, or perhaps you can hunt down the duplicate and fix it at the source. The easiest way to find the duplicate is to create a measure to count the customer ID column, then drop that column and that measure on a table visual, sort by the measure and see which ones come up more than 1.