Forum Discussion

kalimotxo's avatar
kalimotxo
New Member
8 years ago
Solved

SELECT DISTINCT Returning Duplicate Strings

Hello All,   I have a query that I am running which is SELECT DISTINCT. It is a simple query with only one string field in the results. There are multiple WHERE conditions, and then a ORDER BY.   ...
  • Rfranca's avatar
    Rfranca
    8 years ago

    hi, kalimotxo

     

    Have you checked that the records in the LOCALIZATION column contain values with white spaces or special characters?

    This is often the case, so there are duplications.
    Use POWER EDITOR QUERY functions to perform this cleaning.

     

    Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

    Best Regards,
    Rfranca

Rfranca's avatar
Rfranca
Resolver IV
8 years ago

hi, kalimotxo

 

Have you checked that the records in the LOCALIZATION column contain values with white spaces or special characters?

This is often the case, so there are duplications.
Use POWER EDITOR QUERY functions to perform this cleaning.

 

Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

Best Regards,
Rfranca

  • kalimotxo's avatar
    kalimotxo
    New Member
    8 years ago

    Selecting text as the format, despite it already being the default, seems to have worked. I don't know why, but it did!