I have a list with employee names all in upper case. E.g. DANIEL SMITH
How can I convert these names in Anaplan to Daniel Smith (upper case on the first letter then lower case for the remaining)
Hi @RebeccaL - you'd need to use a combination of Left, Right, etc to get the desired result. There is this very old idea about having Proper() as a function within the platform.
Thank you, I think the function of Proper would be really helpful in Anaplan. Calculations can be used to get around this when it is a simple case of first and last name. I have some employee names where they have 2 middles name so it gets a bit complicated.
Hey , you can use lower(name(item)) to convert it to lower case
@Kanishq17 I guess he needs it to be in initial case, where you capitalize the first letter of every word. At present I don't think so we have any functions like that, we have UPPER, LOWER, LEFT, RIGHT functions to do the transformations.
Daniel Smith - upper case on the first letter then lower case for the remaining we don't have any function for such conversion in Anaplan currently.
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
We have 2 dataspaces (Training and Current), the training one had a link to a list in a Model. When i tried to add a link to the same list in the Current dataspace, the link showed as ticked and i could not select it. Does this mean you cannot link to the same source in 2 different dataspaces? It shows a tick in the LINK…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
