Hi There.
I had a query regarding storing variable values.
What i want to achieve:
Suppose a variable named vID is created.
We assign some value to it Say 'Swtnk02'
i want to store it in some table such that when we change the variable value to 'Pk0012'
the table will consist both Swtnk01 and Pk0012 in it and so on.
I tried doing this but still the data gets updated for the latest Variable value given
UserDetail:
Load * Inline [
Id,Type
P01,Principal
P02,Principal
S01,Student
S02,Student
T01,Teacher
T02,Teacher
$(vID),$(vType)
];
Store UserDetail into [lib://DataFiles/userDetails.qvd](qvd);
Drop table UserDetail;
LOAD
Id,
"Type"
FROM [lib://DataFiles/userDetails.qvd]
(qvd);
