Forum Discussion
1st year Status
Hi xifeng_L , thank you for your answer but I can't do that because the Idnummer is repeated (one or more per month).
By the way I found a solution : I copy the table. I group it per Name and I choose minimum Date. Then I join table2 to the initial Table and I let appear the column minimum firstdate.
Regards,
Frances
Super UserThey can have several IDnumbers but I managed to have only one Name per employee.Shouldn't that be the other way round? Name changes may occur but IDs should stay the same.
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Hello lbendlin ,
I totally agree, but the HR management tool has been changed and a new ID number has been assigned to each employee. The interesting thing is that sometimes the same employee has a new ID number when he changes function. So I created a register with an index and a unique name for each employee, because there were also name differences in the two HR systems. I could use the index, but in tables and graphs, I have to use the name, and it has to be unique for everything to be correct.
By the way I found a solution : I copy the table. I group it per Name and I choose minimum Date. Then I join table2 to the initial Table and I let appear the column minimum firstdate and do some transformation to have it not repeated.