This content has been marked as final. Show 5 replies
I have a set of variable
I like to create a NewColumn that depends from the columns ‘Var_Index’ and ‘Value’
For example, the first line Var_Index=1, Value=10 then NewColumn=$(var1(10))=10+1=11
$(var&Var_Index(Value)) as NewColumn
My code doesn’t work, how can I modify it that it works.
I try to avoid pick(Var_Index,…) and If(Var_Index=….) because my list of variable is longer than this sample and I create the variable dynamically.
Thanks for your help and answer.
Nice Week End!