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
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.β¦
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the nodeβ¦
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create aβ¦
