Can someone please view this and help me how to set this in a right way?
7.2.3 Activity: Import Data into Employee Details Module
In the model, open the SYS08 Employee Details module
Preview of Employees.csv
DO NOT open the .csv file in Excel before completing the import.
The Code used for each employee is text that contains leading zeros (e.g., 001, 002). If you open the file before importing, Excel will automatically convert the Code to numbers without the leading zeros (e.g., 1, 2), which may cause a mismatch in Codes later in the course.
A preview of the data contained in the .csv file is shown above and is also visible during the import process.
If you already opened the .csv file and see that the Code contains numbers without the leading zeros (e.g., 1, 2), delete the file and download it again using the link above.
In the SYS08 Employee Details module
(opens in a new tab)
- Import the data file into the SYS08 Employee Details module
- Review the File Options and confirm the Header and First Data rows are correct
- Verify the source to target mapping for each dimension
- HINT: The E2 Employees# list is a numbered list and each record is assigned a unique identifier. When mapping the data, you should not map by name or map manually.
- Do not populate the Department line item during the import. You will add a formula to this line item in the next activity.
This import process will populate the module with Name, Country, Start Date, Leave Date, Current Salary, and Commission % data.