Level 1 Importing data into list

  • I am in Level 1, where as an 4.8.2 Activity I have to import data from Employees.csv into

IMG_20211004_164321.jpg

  •  

E2 Employees#  numbered list. But while importing it is showing Invalid parent. Please help. I am attaching picture

IMG_20211004_164335.jpg

Best Answers

  • @amruthasai7979 

    The mapping seems correct. Kindly check the Department codes in the Department List, it might be missing. Also verify if the Department List is set as a parent of the Employees List.

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • @amruthasai7979 

    Follow the snip below for setting up the Department list as a parent of Employee list.

    anandshekhawat_0-1633350396793.png

     

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • @amruthasai7979 

    Kindly check the department codes. Follow the below snip for reference

    anandshekhawat_0-1633352753299.png

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • It seems like you have missed some steps to create the Departments List members. It's Ok you can create it manually, looking at the snip I have shared.

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • @amruthasai7979 

    So in here you were trying to import the Employees(child) data under departments(parent). Initially while importing the file you had defined the employees list to go and sit under the respective department. But the departments list members were absent, so Anaplan did not find the correct parent under which it should load the Employee data, that is why it threw the error. After when you created the department list members Anaplan was able to locate the correct parent, so the data got loaded with ease. 

    I believe there would an import that needs to be done for creating the departments list. In the above case the departments were very few, that is why i advised you to create manually. Suppose the data would have hundreds of entries, it would be difficult as well as error prone, to manually type in the data. So in that case an import from csv would be the best option.

    In the end its you who has to decide how to feed the data into the model seamlessly and keeping it error free.

     

    I hope i have answered your question.

     

    ~Anand

     

    https://in.linkedin.com/in/anand-shekhawat-35645486

Answers