Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Duplicates

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..

10 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this.

LOad Distinct Upper(Seller) as Seller,sales inline [

Seller,       sales

4thmm,     10

4Thmm,    10

98ku,         20

98KU,        20

tte,             30

TTe,           30

];

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
zhadrakas
Specialist II
Specialist II

i tried this and it seems to work correct

Load Distinct lower(Seller) as Seller,
sales
;

LOAD * INLINE [
Seller ,sales
4thmm ,10
4Thmm ,10
98ku ,20
98KU ,20
tte ,30
TTe ,30
]
;

nareshthavidishetty
Creator III
Creator III
Author

Hi,

We don't need to change the case of the seller.

Instead of that is it possible to pull only first value.

Thanks..

zhadrakas
Specialist II
Specialist II

upper or lower doesnt matter at this Point.

The important word for you is Load distinct

sasikanth
Master
Master

Hi,

While fetching data from database use UPPER function in every load and then store data  into QVDS.

DB Load:

Load UPPER(Seller ) as Seller,

         sales ;

SQL Select * from scehma.dbo.table;

Load QVDs in to qlikview

Load  Seller , sales from SQLQVD.qvd;

Load Seller,sales from TERADATA.qvd where not exists(Seller) ;


nareshthavidishetty
Creator III
Creator III
Author

Hi,

Its not working.

Thanks...

sasikanth
Master
Master

Please share your application if you can

nareshthavidishetty
Creator III
Creator III
Author

Hi,

Attached is the sample data.

Thanks..

nareshthavidishetty
Creator III
Creator III
Author

Hi,

Any suggestions.

Thanks..