How to store Variable values anywhere be it QVD or table or inline

Swtnk02 — Wed, 21 Dec 2022 06:52:27 GMT

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);

Re: How to store Variable values anywhere be it QVD or table or inline

Swtnk02 — Wed, 28 Dec 2022 09:19:03 GMT

*found a way