I am currently self learning L1, on Anaplan and unable to set this prompt in a practice session.

vzala1
vzala1
in Modeling

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

image-2548dc0cca07b-3ff7.jpeg

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.

Best Answers

  • seymatas1
    seymatas1
    Answer ✓

    Hi @vzala1,

    1. Open your model and go to the SYS08 module.

    2. Click Data → Import.

    image.png

    3. Upload the new file and set the default file access to Admins only.

    image.png

    4. Map the file using the screenshots below.

    image.png

    5. Open the E2 Employees tab.

    image.png

    6. Open the SYS08 Employee Details Line Items tab.

    image.png

    Ignore the Role line item in my screenshot for now, you’ll come back to it later.

    I hope this helps.

    Seyma 🌷🙂

  • vzala1
    vzala1
    Answer ✓

    Thank you everyone for the help and guidance :)

Answers

Categories