Call a variable with field value

[jaymerry]

Hello,

I have the following variables :

LET vTEST = A;

LET vTEST1 = B;

And I have the following table which is loaded in my load script :

TEST_TABLE:

LOAD * INLINE

Product, VAL

Bottles, vTEST

Cars, vTEST2

];

Now, in my Dashboard, I'm trying to call the variables in a chart table with the field "VAL" of my TEST_TABLE (I have try  ='$'&'('&(VAL)&')' but it doesn't work )

Do you know if it's possible ?

Thanks for your help,

BR,

Jaymerry

[danielrozental]

I think inline will always take values as literals.

you can try using a mapping table or something like

TEST_TABLE:

LOAD

'Bottles' as Product,

'$(vTEST)' as Bottles

autogenerate(1);

LOAD

'Cars' as Product,

'$(vTEST1)' as Bottles

autogenerate(1);