nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error on importing data onto employee details module

Hemang

Hi,

I am trying to import data onto employee details module. It is a numbered module. I have attached three screen shots, 1. How it should be. 2. How it is and 3. the mapping which I have done.

Please can anyone help?

how it should be.jpg

how it is.jpg

mapping.jpg

Accepted answers

All comments

devrathahuja

Hi @Hemang ,
Can you also add the screenshot of the line items tab in the mapping?

lokeshm

@Hemang clear the code names and make it blank before you import and check whether using text format or date format for the start date line item .

unknown

This content has been removed.

Hemang

Hi Devrath,

Thank you for your reply. please find attached the screenshot for mapping. When I select column headers for Employee details and go to employee details tab to map manually the target column is blank, I have attached the screenshot.

Mapping tab.jpg

Target item.jpg

Hemang

Hi Lokesh,

Thank you. If I make code blank it is showing error?

devrathahuja

Hi @Hemang ,
Clear the code line item & then reimport it without mapping any column from the file to that line item as you can fetch the code using the formula - code(item(____))

Hemang

Hi @devrathahuja,

removing code line item is not showing any values for column headers? If I have understood you correctly, please?

Without code line item.jpg

devrathahuja

Hi @Hemang ,
Map the employee code to the employees column & in the 2nd tab where you map the line items do not map anything to the "CODE" line item.

Hemang

Hi @devrathahuja,

Thank you and really sorry but I am sure I am making some error I have mapped E2 Employee with code and the second column if I leave it as blank it is showing error?

leave 2nd column blank.jpg

devrathahuja

@Hemang - 2nd option you can select column headers & then in the mapping of these columns, leave the code line item mapping blank.

Hemang

@devrathahuja - working now, thank you so much.

unknown

This content has been removed.

unknown

This content has been removed.

Quick Links

Can you help?

Unanswered questions

An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
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.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…