About Chmacpherson

Hello,   Question I am trying to retrieve the display name from a numbered list and then convert it to text (i.e., keep my new line item as a Text Field).   Do you, or does anyone, know how to accomplish this?   Additional Context My numbered list is comprised of employee IDs The Display names are the actual employee names. This is what I need appearing in a module where I am creating a text field. Many thanks, Chad ... View more

Hey @ShivankurSharma,   Wat was your solution to this? I am running into the same issue and am lost on  how to solve it.   Any details or directions would be immensely helpful.   Many thanks, Chad   ... View more

Thank you! Super helpful ... View more

  I struggled with this as well and had to search multiple threads for the answer, so here is hopefully a more concise version of the various solutions. *View the screenshots for a little guide*   1) Make sure your E2 Employees# list is properly set up as a numbered list. Refer to Model Builder 1 lessons: 4.3.4 4.5.4 4.8.2 2) As the E2 Employees# list is a numbered list, you need to map the Target "E2 Employees#" to Column 2: Code instead of Column 1: Employees as Anaplan will not be able to match 001 to Shala Engle.   3) The dates in the csv file are formatted as "Fixed-position" patterns (YYYYMMDD) versus a "With Separators" pattern (YYYY-MM-DD). You'll need to tell Anaplan this when mapping to ensure it reads these as dates.   I hope this helps, Chad ... View more