Export calculated value of a variable from a load script to a text file

covenant_bi — Sat, 16 Nov 2024 02:15:38 GMT

We have a need to export the value of a variable to a text file that can be read by a downstream program. It is a very simple variable, it just sums a field, but we can't get the txt file to get the right output

NPCondition is field that gets created via a resident load and we are looking to sum the values of it and send that sum to a txt file. For testing purposes, when I comment out all lines except the first, the variable calculates correctly in the Edit/dev side of Sense when used with $ sign expansion. When we turn on the rest of the script, though, the output is either the text (the actual phrase sum(NPCondition) or nothing. Any thoughts?

LET vNPConditionSum ='=sum(NPCondition)';
LET vNPConditionFlag = Peek('$(vNPConditionSum)');
CheckTable:
Load '$(vNPConditionFlag)' as NPConditionFlag
AutoGenerate 1;
Store NPConditionFlag from CheckTable into 'lib://Data/test.txt' (txt);

topic Export calculated value of a variable from a load script to a text file in App Development

Export calculated value of a variable from a load script to a text file