I am struggling with my mapping and import of E2 Employee List

edited November 2022 in Academy Discussions

Hello Model Builders!


I need your help in Model Building. I have tried over 10 times to import data into E2 Employees# under Lesson 4.8.2. I have spoken to some colleagues on my team and the we were unable to resolve this issue. If anyone could assist please share a solution or trick to this. 


I noticed other colleagues had 4 sources and property lists in the dialogue box but i seem to have 5. I don't know how.


I have tried some of the mapping solutions on here and all i get is the numbers imported instead of names. 


Any help i can get would be much appreciated! Screenshot 2022-07-21 at 23.33.38.png





  • JaredDolich
    edited November 2022


    You're super super close. Remember with numbered lists Anaplan assigns the name, so you cannot map to an employee "name" because Anaplan has no idea what that means. Your only other option is to map to CODE. When mapping to a list, leave the name blank. That should work for you!

  • Amina12
    edited November 2022
    It worked !!!!!! Thanks for the support offered. I can happily continue model building
  • laxmitater
    edited November 2022


    i am unable to map the employee list. KIndly help!

  • aangelan

    It is:

    Code for Code

    Active? for Active line

    Name for Display name

    Everything else is blank!

  • BESS

    What do you mean by "Name" for Display Name? "Column 1: Employees"? Stuck on this one.

  • BESS

    Not sure what the issue is with invalid parent. Any help is highly appreciated

  • ganeshd10

    Hi @BESS , you are almost there. For Display Name? , you need to map "Column 1: Employees"? 

    Also, for invalid parent, looks like your E1 department has Department codes missing. Please do check once.

    Happy to help!