I have a very simple (but large) Staff table that gets updated more frequently than I would like it to be. Because of this, I am trying to put in into QV to help automate some reports.
The issue: for most of my reports, I only care about my Employee ID Number (EIN) and the Manager that is associated with them for this duplicate identificaiton. My list though includes the various Name variations we have on file for any given employee. I want to recreate this list, but remove any duplicates. Here is some basic sample.
I thought I could create a "mapping" script to de-dup, but apparently I am still not good enough at this as none of the versions I have tried actually remove the duplicates.
Here is what I thought would work but does not as I still have duplicates:
Staff_Mapping: Mapping LOADDistinct EIN, Manager FROM (ooxml, embeddedlabels, tableis UpdatedUserList);
Staff_List: LOAD Login, UserName, Title, Manager,, EIN, EINas[Nurse Decode #], ApplyMap('Staff_Mapping', EIN) asUniqueFlag FROM (ooxml, embeddedlabels, tableis UpdatedUserList);
Thank you in advance for your help in getting these duplicates removed!
Re: De-duplicating Simple Data Table in Load Script
Yes, I only need one of the rows (don't really care which one), I just need a list with one unique EIN and the respective columns that go with it (again, don't care which one). While this sample is simple, I have a list of hundreds of employees and there are a quite a few employees that have 5 or even 6 iterations of their names.