Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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..

Tags (1)
10 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Duplicates

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Specialist II
Specialist II

Re: Duplicates

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
]
;

Highlighted
Creator III
Creator III

Re: Duplicates

Hi,

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

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

Thanks..

Highlighted
Specialist II
Specialist II

Re: Duplicates

upper or lower doesnt matter at this Point.

The important word for you is Load distinct

Highlighted
Specialist III
Specialist III

Re: Duplicates

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) ;


Highlighted
Creator III
Creator III

Re: Duplicates

Hi,

Its not working.

Thanks...

Highlighted
Specialist III
Specialist III

Re: Duplicates

Please share your application if you can

Highlighted
Creator III
Creator III

Re: Duplicates

Hi,

Attached is the sample data.

Thanks..

Highlighted
Creator III
Creator III

Re: Duplicates

Hi,

Any suggestions.

Thanks..