How to add a prefix to specific members in Data Load Mapping
Having trouble mapping a prefix and no prefix while loading employee data.
I am trying to load employee data using employee number. In our source file, the employee number column contains two identifiers 1) a 6 digit employee number or 2) the words Total Reps. Our employee numbers in PBCS all have the prefix EMP_. Total Reps is a base member in the employee list, but it does not have the EMP_ prefix.
I need to map three things:
- the employee numbers to the EMP_employee number
- Total Reps to Total Reps
- a catchall to Other Employees for any employee numbers not in the app