Variable to QVD

[rash_611]

Hi,

i have a syn. where i need to find the parent call and child calls for each Callnos. So need do some calculation in For Loop having a variable help. but the result of the variable has to be stores in QVD for each callno.

Can any one help on this storing issue.

Regards,

Grace

[CELAMBARASAN · Accepted solution]

Create a Table like

VariableResults:

Load 1 AS CallNo, '' AS VarResult Autogenerate 1;

after that assume your variable is vResult

for i=0 to 10

Let vResult = i *30;

Load $(i) AS CallNo, $(vResult) AS VarResult Autogenerate 1; //it will store the callno and varresult to the table called //VaraibleResults

next

Store VariableResults INTO QVDPATH/VaraibleResults.qvd(qvd);

[rash_611]

thnks for the reply. but whether it will work for 100 different callnos.

[CELAMBARASAN]

yeah it will work for any number callnos

[rash_611]

thnks a lot. its working