Exploring TM1 - a Chartertech Company
Search
Close this search box.

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.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

John Vaughan

John Vaughan

John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In