Hi experts,
How to write "concatenate formula" in anaplan.
We have 3 proprties in Customer list. I want to concatenate first and second properties into 3rd property.
The format of the properties is "Text".
Can you please suggest me.
Regards,
Uma
Hi,
Assuming all 3 properties are Text format, then
Properties 3 = 'Properties 1' & 'Properties 2'
If Properties 1 and/or Properties 2 are of List format, then you can use NAME() or CODE().
In alignment with the S(ystem) of DISCO, this should be in a List Properties MODULE, not in the LIST properties.
Thanks,
LipChean
You can just use & after every text item and this will concatenate. Here is a link to the Anapedia page.
@UMAMAHESH @AWhitworth
please refer to this article for guidance on how to use concatenation in the most efficient way
https://community.anaplan.com/t5/Knowledge/Formula-Optimization-in-Anaplan/ta-p/41663
David
I live in Colombia and the weather changes a lot here. So I have to look at the weather forecast every day to get dressed properly. It's good that I found this https://tiempo.info/colombia site because it always has the most accurate weather forecasts in Colombia. I'm glad I found it because now I always know what weather to expect. I advise you to use it too if you don't know where to look for accurate weather forecasts
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
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…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
