Having issues to elimniate duplicate

[#1]

I am facing a challenge to remove duplicates of employee numbers in a pivot..any help would be appreciated...

[sujeetsingh]

First of all at first it seems there is one to many relationship  in data model due to null values. Please provide a complete details of the table you are using and the data  you are reloading .

[SreeniJD]

Venkat -

Try this

Sometimes, if you have some space or anything in the source data, it will not be treated as NULL.. so use function such as len(trim(field_name))=0...

HTH

Sreeni