Handling duplicate records

[engr_farhanqadr]

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

[jyothish8807]

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

Regards

KC

[arulsettu]

hi

Use the DISTINCT keyword in the LOAD

thanks

[#4]

Hi,

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

Example:

load  *

**Your Fields***

RecNo()

From **location**

[engr_farhanqadr]

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.

[arulsettu]

have u tried my suggestion?

[engr_farhanqadr]

Murali,

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

[engr_farhanqadr]

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.

[alkesh_sharma]

IN the Script use upper or Lower function

Load Distinct *,

Lower(Your Field with duplicate value) AS Name

From XXX

Hope this helps