L1 Model Building - Lesson 7 Data Mapping issue.

zaibhamid81

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.

 

 

Any help will be appreciated.

 

Thanks

Zeb

 

 

 

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

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

Hi

 

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 

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.