Forum Discussion
Employee diversity by date - expanded table?
Hello! I have diversity data for my company in the below format. My table is called DEI Detail Employee ID, Start Date, Term Date, Gender, Race I need to be able to use this data much more d...
I appreciate your offer.
Note - not everyone has a termination date, because they still work here. As evidenced by the double comma's
Employee Unique Identifier,Fulltime Hire Date,Termination Date,Gender,Race - Ethnicity
1128650,08/20/18,06/24/20,M,Hispanic
914688,05/20/19,06/24/20,M,White
11248288,01/27/20,06/24/20,M,Hispanic
11243535,08/24/20,,M,Asian
8192101,10/26/09,,F,White
289433,01/01/14,,F,White
8135459,08/01/20,,F,Black
678699,10/15/18,,M,Hispanic