Activity 7.2.3 Importing into Employee Details

Please help with data import query.

My file is not loading correctly despite several attempts.

Name: most rows are empty, I am not sure why only a few are bringing the Name up

Same with Country only a few which also have the name in the them

For Name & Country it didn't automatically map, I had to manually map - why not mapping automatically

Imported but with a lot of errors.

Also I'm not sure why its putting a sum value after every department - see View after import.

Thanks in anticipation,

Joyce

Employee_mapping_tab_91287.PNG

Employees_91287.csv

Error_details_91287.PNG

Import_completed_but_with_failures_91287.PNG

Mapping_91287.PNG

Line_items_mapping_91287.PNG

View_after_import_91287.PNG

Tags

Importing and Exporting Data

Data Integration

Accepted answers

Hello Joyce @jmwoyounotswa

please reference the link below for an answer to your question

https://community.anaplan.com/t5/Academy-Training/Error-in-level-1-Activity-7-2-3-Unable-to-Import-Name-Department/m-p/87948#M2490

All comments

Hello Joyce @jmwoyounotswa

please reference the link below for an answer to your question

https://community.anaplan.com/t5/Academy-Training/Error-in-level-1-Activity-7-2-3-Unable-to-Import-Name-Department/m-p/87948#M2490

Thank you, it helped, I went bank to Employee List 4.54 to 4.8.2 and reviewed. I imported again in 7.2.3 & it worked.

Thank you

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385