CONCATENATE Formula in anaplan

Contributor

CONCATENATE Formula in anaplan

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

Message 1 of 4
3 REPLIES 3
Super Contributor

Re: CONCATENATE Formula in anaplan

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

Message 2 of 4
Certified Master Anaplanner

Re: CONCATENATE Formula in anaplan

You can just use & after every text item and this will concatenate. Here is a link to the Anapedia page. 

 

 

Message 3 of 4
Community Boss

Re: CONCATENATE Formula in anaplan

@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

Message 4 of 4