topic Remove Dupicate records for Active/Inactive Employees in QlikView

Remove Dupicate records for Active/Inactive Employees

Anonymous — Sat, 14 May 2016 09:24:11 GMT

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 — Sat, 14 May 2016 09:50:35 GMT

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

Kushal_Chawda — Sat, 14 May 2016 10:22:30 GMT

I do not see any duplicates.

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

Anonymous — Sat, 14 May 2016 10:38:13 GMT

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 — Sat, 14 May 2016 10:52:11 GMT

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 — Mon, 16 May 2016 08:51:49 GMT

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

Anonymous — Mon, 16 May 2016 08:56:33 GMT

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

Kindest Regards

Brian