How to Remove Duplicate Names

[krishna20]

Hi Folks,

I'm having Employee_ID which is Identical but Employee_Name getting duplicates from Database itself.I need to restrict it in the Qlikview script .how can we achieve it? Please anyone suggest me. Please find the attached image.

Regards

Krishna

[sunny_talwar]

May be try loading the Employee_ID with DISTINCT keyword

[jsingh71]

share some sample data.

[#4]

Hi,

Try to find frequency of your EMP_ID (97) if it is giving 2 then load distinct data it will work...

[krishna20]

Hi All,

Thank you for valuable replies. I tried using Distinct keyword in different Scenario's but no use. I have tried at PERSON_ID and EMPLOYEE_ID and EMPLOYEE_NAME.

Employee name is still getting duplicates.If you observe that in the app or above attached image. There is name difference in the both. Please find the attached app.

Regards

Krishna

[#6]

Hi,

restrict it with below clause if only single name giving trouble,

FROM

(qvd) where [Employee Full Name]<>'Ray, Ms. Amy (Amy)';

[jonathandienst]

You have not explained what you want to do with the duplicates. You could take the first instance of the ID and ignore subsequent duplicates, you could use a date field (if one exists) to choose the most recent, you could ignore the ID and just take the names, you could exception report the duplicates on an integrity report, etc.

So what do you want to do?

[#8]

Hi

Use DISTINCT keyword or first sorted value

Thanks

[Kushal_Chawda]

There is multiple employees name for single Employee ID which is not possible. Check your mapping.

[kavita25]

What is the expected result instead of 8??

Regards,

Kavita