Duplicates

[nareshthavidishetty]

Hi,

We have a field called Seller.

We pull the seller detail from two systems like SQL DB and teradata.

After we load the information in qlikview we got duplicates due to case sensitive as below.

Seller       sales

4thmm     10

4Thmm    10

98ku         20

98KU        20

tte             30

TTe           30

when we do a sum(sales) as dimension as seller we got huge count due to duplicates.

How to remove the duplicated.

I have used the upper(Seller) ,but it removes the seller name start with numeric.

Thanks..

[Or]

I can confirm that the Lower() approach suggested above works correctly, as does Upper() and Capitalize(). These have to be done in LOAD, not in your SELECT - otherwise your DBs may treat strings differently.

You do need to change the case of the seller, because AAA and aaa are NOT the same thing. You have to pick one and remove the other, and the way to do that is to use lower(), upper(), or capitalize().