How to create a Table

[madhubabum]

Hi All

I have the following scenario,......

YearRange:

Load Max(Year) as MaxYear, Min(Year) as MinYear resident Table1;

Let vMaxYear= Peek('MaxYear',0,'YearRange');

Let vMinYear= Peek('MinYear',0,'YearRange');

Set vRangeMax=$(vMaxYear);

Set vRangeMin=$(vMinYear);

Drop Table YearRange;

Do

Load

$(vRangeMax) as Year

Resident Table1

where Year=$(vRangeMax)-1;

Set vRangeMax= Num($(vRangeMax))-1;

LOOP while $(vRangeMax) >$(vRangeMin);

Store Table1 into 'D:\Table1.qvd';

Note : " $(vRangeMax) "   is showing an error......

How we can load table...

Thanks

Madhu

[sasiparupudi1]

Hi

Is your problem solved?