TM1 Forum

Hi all

is there a code that allows me to combine avariable value with a string to make a variable name,

i.e

i1 = Test
c= 1


cellputn("testcube", 'I'|numbertostring(c),Tester)

I want to turn this:
'I'|numbertostring(c)
into this
i1

in excel this would be indirect what is this in TM1 TI code ?

thanks all

http://www.tm1forum.com/viewtopic.php?f=21&t=4921

or search for indirect variables! Search box is in the top right.

Lol Steve ta m8 I did actually search for that weirdly that didn't pop up but I thought it had to be in the system as its a major player in making extremely dynamic programming,

For those that find this post and can't be bothered clicking the link above.. It's EXPAND()

Maybe you splet variables wrong in the serach box?

Steve Rowe wrote:Maybe you splet variables wrong in the serach box?

LOL... look at the topic title

shhh Wim Gielis