2 variables combined to make 1

[Darkhorse]

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

[Steve Rowe]

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

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

[Darkhorse]

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()

[Steve Rowe]

Maybe you splet variables wrong in the serach box?

[Wim Gielis]

Maybe you splet variables wrong in the serach box?

LOL... look at the topic title

[Darkhorse]

shhh Wim Gielis