Duplicates in Table

[qlikuser22]

Hi 

I have a table with customer details. I am loading data from SQL database. My data is getting loaded properly, but when i visualize, I have a customer details table in qliksense. I can see the values are getting duplicated but it is not affecting my KPI. But to visualize the table, it looks odd. 

The values are duplicated one with capital and one with lowercase letters. In the database, there are only Uppercase. 

please help me.

Example:

Customer Name   CustID   Location    State City

ABC                             123         xxxx             yyyy

abc                              123          xxxx             yyyy

How should I solve this. I loaded the data using LOAD DISTINCT .. 

Also I tried using Noconcatenate. 

[QFabian]

Hi @qlikuser22 , when loading fields, try CAPITALIZE([Customer Name]) as Customer Name, to avoid that kind of differences.

[qlikuser22]

Thanks for the reply. I tried. I still have both the names. Lowe and uppercase. 

[Sammy_AK]

try upper (<fleid Name>) , Upper([Customer Name]) as Customer Name, 

[qlikuser22]

Hi. 

Thanks. I can see changes in my table but still I have few more duplicates. I had more than 400 duplicates, but by using Upper(Customer Name), the duplicates reduced to 100. But still I face the issue. Any suggestion please. 

[Sammy_AK · Accepted solution]

try using trim(upper([Customer Name])), this will help to remove trailing spaces which can also be a root cause for duplicates.