Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
is it possible make a table (graph) for the script?
I have 100 measures to be insert in the graph (table) and manually it is very tiring to do it.
Thanks
No I guess you have to do it manually.
You could store them in excel and load the values into your script. Still at some point you are going to have to generate the list by hand unless you have some friendly field names.
I do this with loading variables
LOAD
"Variable Name",
"Variable Expression",
"Variable Comment"
FROM 'lib://Config/<filename>.xlsx'
(ooxml, embedded labels, table is Variables);
For i = 0 to NoOfRows('Variables') - 1
Let vName = Peek('Variable Name',i,'Variables'); // Name of Variable
Let vComment = Peek('Variable Comment',i,'Variables'); // Comment/Description of Variable
Let $(vName) = Peek('Variable Expression',i,'Variables') & chr(10) & '//$(vComment)'; // Default value
Next i
Regards
Andy