Forum Discussion

FrancesHolland's avatar
FrancesHolland
Frequent Visitor
1 year ago
Solved

1st year Status

Hi to all, I have some data about employees. They can have several IDnumbers but I managed to have only one Name per employee. A same employee can have several rows for the same period. Some of t...
  • FrancesHolland's avatar
    FrancesHolland
    1 year ago

    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 

FrancesHolland's avatar
FrancesHolland
Frequent Visitor
1 year ago

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 

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi FrancesHolland , We are happy to hear that you have found the cause and resolved the issue. Thanks for sharing the details here.  Please mark your insights 'Accept as solution' to help others with similar problems find it easily. 
Thank you.