Sometimes you encounter a need for an adhoc import or export of variables.
Code for load variables from another QVW.
VariableDescription:
LOAD
Name,
RawValue
FROM [..\..\data\StudentFile.qvw]
(XmlSimple, Table is [DocumentSummary/VariableDescription])
Where IsConfig = 'false' and IsReserved = 'false' // Exclude system vars
// Any addtional filtering here
;
FOR idx=0 to NoOfRows('VariableDescription')-1
LET vVarname = Peek('Name',$(idx),'VariableDescription');
LET [$(vVarname)] = Peek('RawValue',$(idx),'VariableDescription');
NEXT idx
SET idx=;
SET vVarname=;
DROP Table VariableDescription
No comments:
Post a Comment