Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 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 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:
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