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.
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.
LOad Distinct Upper(Seller) as Seller,sales inline [
i tried this and it seems to work correct
Load Distinct lower(Seller) as Seller,
LOAD * INLINE [
While fetching data from database use UPPER function in every load and then store data into QVDS.
Load UPPER(Seller ) as Seller,
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) ;