Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
So Farhan, what is your requirement? What are you trying to do?
Regards
KC
hi
Use the DISTINCT keyword in the LOAD
thanks
Hi,
Can you use Recno() for keeping each record as unique record.
Example:
load *
**Your Fields***
RecNo()
From **location**
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.
have u tried my suggestion?
Murali,
this adds another field as RecNo() but did not eliminate the problem.
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.
IN the Script use upper or Lower function
Load Distinct *,
Lower(Your Field with duplicate value) AS Name
From XXX
Hope this helps