Evaluate variable on Table

[ericdelaqua]

Evaluate dynamic variable on table using field values

Hello,

I am facing a challenge with evaluating variables on a Table. He is my load script.

Load * Inline[Text
text1
text2
text3
Text4
];  

Let text1= cadeau;
Let text2= 20;
Let text3= 1;
Let Text4= $(text2)+$(text3);

and on my output table I would like to have the following
Dimension
Text

Measure
'='&'''$'&'('&Text&')'''

sample output

Text	Value
Text	cadeau
Text	20
Text	1
Text	21

Please any ideas how this can be archived? Thanks

[ericdelaqua]

Hello,

I am facing a challenge with evaluating variables on a Table. He is my load script.

Load * Inline[Text
text1
text2
text3
Text4
];  

Let text1= cadeau;
Let text2= 20;
Let text3= 1;
Let Text4= $(text2)+$(text3);

and on my output table I would like to have the following
Dimension
Text

Measure
'='&'''$'&'('&Text&')'''

sample output

Text	Value
Text	cadeau
Text	20
Text	1
Text	21

Please any ideas how this can be archived? Thanks

[Taoufiq_Zarra · Accepted solution]

@ericdelaqua  why not adding mapping table

like this :

let text1= 'cadeau';
Let text2=20;
Let text3=1;
Let Text4= '$(text2)'+'$(text3)';

Map1:

mapping load * inline [
Text,value
text1,$(text1) 
text2,$(text2) 
text3,$(text3) 
Text4,$(Text4) 
];

Data:
Load *,applymap('Map1',Text) as Value Inline [
Text
text1
text2
text3
Text4
];

output:

[ericdelaqua]

@Taoufiq_Zarra 

Thanks for your suggestion I actually lost this question so I recreated it here and got an answer. I didn't realise it was kept. I will try your suggestion too. Thanks 

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-evaluate-value-in-variable/m-p/1827265/highli...