how to use variable values as field name??

[#1]

hi there,

i want to use variable values as a filed name. is it possible??

if yes please share your ideas.

thank you

[krishnacbe]

Yes we can use the values as field name.

But explain what is your requirement to give more details.

[Anonymous]

Define the variable in the name field or write the variable expression in the name field.

[Clever_Anjos]

LET myvar='afield';

LOAD

    field1,

    $(myvar) as [$(myvar)]

from yourqvd(qvd);

[#5]

ok,  i have variables and If i want use to use it for calculation can i use it like this

=XIRR(($(vValue2))($(vValue)))

vVlaue and vValue2 are the variable holding date and amount.