About Chmacpherson

Thanks for this solution!   Modification for DateTime Text String My text line item was formatted as DateTime (e.g., 8/3/2021 4:52:47), so I modified Misbah's solution to the following:     Notes Used the MID function to find the year - found the second "/" and added a +1 to set the start position. Flipped the Day and Month calculations. ... View more

Ah no that is my bad. I did not mention not (I did not realize its importance. Thank you again! ... View more

Thank you for your help trying to solve this! I am not sure why the above did not work, but I believe the Item(Time) portion wasnt working because the Destination/Target module had the time scale set to day. All the best, Chad ... View more

Thank you for your help solving this!   You were correct that the destination/target module which has the time dimension has the time scale set to day. I used the FIRSTNONBLANK formula just as prescribed and that worked like a charm.   Thank you again for the help and the quick reply!   All the best, Chad ... View more

Thanks Jared for the details around why the boxes are disabled.   Additional details around the solution: The user role must have access to all modules visible on a dashboard In our case, we had modules associated with filters on a dashboard (to enable multi select), which was the culprit as we missed adding read/write access to these modules.   All the best, Chad ... View more

Hey Rob,   Thank you for your speedy reply and apologies for my delay.   You raise a great point. I was heading down an unrealistic path, so this point helped me reframe what the issue was and approach it from a different angle.   Many thanks, Chad ... View more

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