I have to get solution like this , see below screenshot
https://community.anaplan.com/profile/sumarendla95 As because of E2 employee is a number list you must map with code insted of nameID.
Thanks
@sumarendla95 As per @jagadishdash comment do the following below
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 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
Thank you @TristanS @jagadishdash @James Martin - Cognizant I got my solution as per your suggestion
When exporting from Anaplan using "Tabular Multiple Column", will the export include only the line items saved in the saved view, or will it also export line items that are excluded from the saved view?
Have noticed that in the last couple of days a couple of Cloudworks integrations have got a status of "Auto_Deactivated". Couldn't find anything in Anapedia and wondered if anyone knew what this was about? Seems to be something about the schedule as deleted the existing one, added it back and is now running fine but isβ¦
Hello, I am trying to understand how the ITEMLEVEL function works. I am reviewing the example shown in Anapedia (https://help.anaplan.com/itemlevel-756d1428-5f1d-4d79-8274-d075a1bd312f) but I do not understand how Result 1 is calculated. For example, why does California returns 0 but Texas 4? Also, Spain returns 3 but UKβ¦
