Forum Discussion

kkanda's avatar
kkanda
Resolver II
1 year ago
Solved

Unable to create relationship between tables

Hello All, This is not a  new problem. When I tried to link two columns of different tables in the Relationship pane, I keep getting the message that one table column must have unique values. I foun...
Need Help
  • kkanda's avatar
    kkanda
    1 year ago

    Hello All, 

    Thank you for your responses to solve my problem. Finally, I found that out of 278K cells, less than 20 cells have text including "?". I removed these rows and I was able to create the relationship. 

kkanda's avatar
kkanda
Resolver II
1 year ago

Hi Ritaf1983 

Thanks for the response. The data types of the columns for both the tables are Text. I checked for blank rows and removed these rows. Both tables are large tables - the main table has 100K rows and the concerned column has repeated text values. It cannot be filtered to contain unique values as we need all rows of the table for further calculations. The second table has 285K rows and that is the table I am working on to get unique values in the related column. This is a large data set and sample values or a truncated tables may not help.