Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
thnks for the reply. but whether it will work for 100 different callnos.
yeah it will work for any number callnos
thnks a lot. its working