topic Re: Handling duplicate records in QlikView

Handling duplicate records

engr_farhanqadr — Thu, 04 Dec 2014 09:57:47 GMT

Dear Folks,

I have made a dashboard in which data has duplicate records like HBL-1643-BROWN and HBL-1643-Brown. In this scenerio I can not use upper or lower case nor capitalize. because I need the record in original shape in one time.

please guide.

Thanks,

Farhan

Re: Handling duplicate records

jyothish8807 — Thu, 04 Dec 2014 09:59:35 GMT

So Farhan, what is your requirement? What are you trying to do?

Regards

Re: Handling duplicate records

arulsettu — Thu, 04 Dec 2014 10:03:34 GMT

Use the DISTINCT keyword in the LOAD

thanks

Re: Handling duplicate records

Thu, 04 Dec 2014 10:18:43 GMT

Hi,

Can you use Recno() for keeping each record as unique record.

Example:

load *

**Your Fields***

RecNo()

From **location**

Re: Handling duplicate records

engr_farhanqadr — Thu, 04 Dec 2014 10:50:55 GMT

I used this field as dimension and there is only one record which has corresponding KPI values other has zero value, I want to show the record only one time which has the values.

Re: Handling duplicate records

arulsettu — Thu, 04 Dec 2014 10:52:48 GMT

have u tried my suggestion?

Re: Handling duplicate records

engr_farhanqadr — Thu, 04 Dec 2014 11:24:33 GMT

Murali,

this adds another field as RecNo() but did not eliminate the problem.

Re: Handling duplicate records

engr_farhanqadr — Thu, 04 Dec 2014 12:24:47 GMT

Yes I tried but It loads both the records because one is in small letter and other is in caps.I need only one record.

Re: Handling duplicate records

alkesh_sharma — Thu, 04 Dec 2014 12:28:30 GMT

IN the Script use upper or Lower function

Load Distinct *,

Lower(Your Field with duplicate value) AS Name

From XXX

Hope this helps