Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
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
];
Hi,
We don't need to change the case of the seller.
Instead of that is it possible to pull only first value.
Thanks..
upper or lower doesnt matter at this Point.
The important word for you is Load distinct
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) ;
Hi,
Its not working.
Thanks...
Please share your application if you can
Hi,
Attached is the sample data.
Thanks..
Hi,
Any suggestions.
Thanks..