Hi, I am trying to map the E2 Employees# list subset mapping , pls tell me how to map here?

sumarendla95

I have to get solution like this , see below screenshot

Accepted answers

jagadishdash

https://community.anaplan.com/profile/sumarendla95 As because of E2 employee is a number list you must map with code insted of nameID.

Thanks

TristanS

@sumarendla95 As per @jagadishdash comment do the following below

All comments

vanreign

I believe this is from LV1 training. Review material on mapping by Name and Code. Generally, you will always map by CODE. A rare example otherwise is where you allow a user to enter a list item, then come back and use a module item to generate a code for that Named Item and populate CODE values for list items. So, in the above example, you are correctly using a Numbered List because Employee Names can be the same, possibly have a length that exceeds 60 characters, and last names can change (marital status, etc) . So JOHN DOE and JOHN DOE, two different employees, would be imported correctly by CODE.

jagadishdash

https://community.anaplan.com/profile/sumarendla95 As because of E2 employee is a number list you must map with code insted of nameID.

Thanks

TristanS

@sumarendla95 As per @jagadishdash comment do the following below

vanreign

@jagadishdash I do not recall the specific function or import situation but there is (unless it has been fixed) an issue where missing CODES from either a standard or number list will cause that item to not be correctly included. Therefore, it is best practice to ALWAYS use CODES on either standard or numbered lists. Additionally, CODES are extremely helpful and efficient when used as defined within the best practice material because they provide item metadata without less efficient functions. For example, list item Production Line 1 is at Manufacture Facility 5 (CODE MF5|PL1) allows a list of Production Lines to be created where line item LEFT(CODE,FIND("|")-1) provides MF5 and FINDITEM(Manufacturer,"MF5") provides the Manufacturer list item.

Cheers,

James

sumarendla95

Thank you @TristanS @jagadishdash @James Martin - Cognizant I got my solution as per your suggestion

Quick Links

Can you help?

Unanswered questions

Importing Data Module 8 Error message
Would someone kindly assist with helping me identify the errors with the following perimeters I have set?
How to get most recent actual year value into a non-time (staging) module and use it for forecast ca
Title: How to get most recent actual year value into a non-time (staging) module and use it for forecast calculations? Question Body: Hello Anaplan Community, I am working on a financial model (Higher-Ed long-range planning) and need guidance on a best-practice pattern to retrieve the most recent actual year value and use…
Access model data outside of assigned workspaces?
I'm using the Integration API 2.0 to list workspaces https://anaplan.docs.apiary.io/#ListUserWorkspaces /workspaces "Retrieves all workspaces a user has access to within the user's default tenant." I'm only assigned to 2 workspaces (which are the only ones visible in the UI also), but this endpoint is returning everything.…