L1 Model Building - Lesson 7 Data Mapping issue.

Hi Everyone,

I am stuck at 7.2.3 Activity: Import Data into Employee Details Module. The instructions are not clear how to map E2 Employee# list ,which is a numbered list, to the .CSV file. There is Hint in the lesson which clearly says this:

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.

This means that I cannot map data against names and also not by mapping manually but i cannot find any other option. Please see the below screenshots.

Screenshot 2022-01-26 at 18.50.15.png

Any help will be appreciated.

Thanks

Zeb

Accepted answers

ManjunathKN

Hi

There is no problem with your mappings, it should be codes--> employees and column headers ---> sys08 module.

but in your 3rd tab that is sys08 module you need to map items manually. and and do custom mappings for start data and end date.

Hope this helps

Thanks,
Manjunath

All comments

ManjunathKN

Hi

Can you try with below settings.

Column 1 --> Emplyoees
Column headers --> sys08

Thanks,
Manjunath

zaibhamid81

Hi Manjunath,

This does not work, as I mentioned that we cannot map E2 Employees# list with names in the .CSV file because it is a numbered list and the employees in that list have been given unique identifier code. Please see the screenshot of the error when I do this.

Thanks

Zeb

ManjunathKN

Hi

if it is numbered list then use the column 2(code)

Column 2 -->employees
Column headers ---> Sys08

Thanks,
Manjunath

zaibhamid81

Hi,

It is still not working with the code in column 2 as these codes in the .CSV file are not the same generated by Anaplan to make the E2 Employee# list numbered list, they are different unique identifier codes.

Many thanks

Zeb

ManjunathKN

It should work! Can you show the mappings and your employees list with codes.

Unique identifier are different like #1,#2 etc and basically you will replace that by text formatted line item as property(display name) in that list.

So numbered can only be mapped with codes and not by names! In any import.

Please show you numbered list in grid view and your mapping.

Thanks,

Manjunath

ManjunathKN

Hope this helps

Thanks,
Manjunath

zaibhamid81

Thank you so much Manjunath for all your help, you are right and your provided solution worked.

Could you just please explain why we have to map Employees against name in the SYS08 tab when we have already selected code column for our numbered list. Why it did not pull out names by mapping code with the E2 Employees numbered list.

Thanks so much for your support so far.

Zeb

rganaplan

Thanks ManjunathKN your answer helped me also.

I was also thrown off by the hint.

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.

shangliuhan111

Thank you for your help

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…