Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule

I was asked the other day how to concatenate some information in TM1. Joining two text fields is really easy!  Just use the pipe ( ” | ” ) between two variables and they will joined into one. There is nothing like the Excel Concatenate function in TM1.

How to Concatenate

Let’s say you have variable 1, sVariable1 = ‘Exploring’; and sVariable2 = ‘TM1’; then using sOutput = sVariable1 | sVariable2; will concatenate those two variable to ‘ExploringTM1’.

Obviously if you need to add other text, include that in single inverted commas and then insert a pipe between that text and your variables. For example use  sOutput = sVariable1 | sVariable2 | ‘ is great’; to get ‘ExploringTM1 is great’.

Pipes can be used in either TM1 Turbo Integrator processes or TM1 rules for the concatenation of data.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.