use variable as function dynamically

yvesqlik — Mon, 26 Jan 2026 18:19:17 GMT

var1= $1+1;

var2=$1+2;

var3=$1+3;

…

my table

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

Load

Value,

$(var& Var_Index(Value)) as NewColumn

Resident Table;

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!

Re: use variable as function dynamically

marcus_sommer — Fri, 21 Oct 2016 11:04:30 GMT