Remove Dupicate records for Active/Inactive Employees

[Anonymous]

Hi All,

I am having duplicate records for Active/Inactive employees.

Removed duplicates using group by and right join,but still having some duplicates.

below is sample data

Please any help will be appreciated

Thanks

Neetha

[Frank_Hartmann]

i cant see any duplicated rows. can u give more details. what should be the output?

[Kushal_Chawda]

I do not see any duplicates.

for 126564, Movement ID is different, for rest Action reason are diffrent

[Anonymous]

Hi Frank,

Thanks for response.

My required output should be , one record per ID ,irrespective of values in other fields(duplicate or not).

remove duplicate IDs

Thanks

Neetha

[Frank_Hartmann]

and which information should be shown for "Action" and "Actionreason"?

You could filter in Load script with where clause

e.g

Load

From

Where Action=XXX and Actionreason=XXX

[Anonymous]

Resolved the issue by just using group by and not joining to main table.

[Anonymous]

Hi

You could have just used load distinct ID if you are not concerned by which duplicated ID record is loaded.

Kindest Regards

Brian