Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Changing data type duplicate some values

i have a table that have around 10k rows, with a column that have unique values, i import these from MySQL with a ODBC connector, and the first 2 columns are like it follow: I sorted A-Z and h...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 

    Would it work if you just right click the column with duplicated rows =>add as new query =>remove duplicates in the list tool => convert to table. After done, you can create a many to one relationship with the new distinct table.

     


    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

Would it work if you just right click the column with duplicated rows =>add as new query =>remove duplicates in the list tool => convert to table. After done, you can create a many to one relationship with the new distinct table.

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.