i created variables...but they did not show..please solve the issue

[#1]

Sales:

LOAD OrderID,

     ProductID,

     Product,

     CustomerID,

     EmployeeID,

     OrderDate,

     Margin,

     Sales,

     Cost,

     Quantity

FROM

C:\Users\PITCHAIAH\Desktop\Sales.xls

(biff, embedded labels, table is [Orders$]);

Sales1:

LOAD *

Resident Sales

Order By OrderDate;

DROP Table Sales;

LET vMinDate=Num(Peek('OrderDate',0,Sales1);

LET vMaxDate=Num(Peek('OrderDate',-1,'Sales1');

[JonnyPoole]

You are missing closing ')' and single quotes in the first

LET vMinDate=Num(Peek('OrderDate',0,'Sales1'));

LET vMaxDate=Num(Peek('OrderDate',-1,'Sales1'));

But do you want a date instead ? just checking...

LET vMinDate=Date(Peek('OrderDate',0,'Sales1'));

LET vMaxDate=Date(Peek('OrderDate',-1,'Sales1'));

[#3]

after closing the ')'.still i did not get them

[#4]

Hi Raja,

You're using a "load * resident" which is causing an auto-concatenation of Sales1 in Sales.

Sales1 is not actually created and cannot be referenced in the peek function.

Simply add a "NoConcatenate" before loading Sales1 and it will work.

[#5]

Thank You

[#6]

i got an error from this code .date($(varMinDate) + rowno() – 1) As TempDate

[#7]

TempCalendar:

Load

date($(vMinDate) + rowno() – 1) As TempDate

Autogenerate

$(vMaxDate) – $(vMinDate) + 1;

Please solve the issue

[JonnyPoole]

you said the error was :  date($(varMinDate) + rowno() – 1) As TempDate

but the code says:   date($(vMinDate) + rowno() – 1) As TempDate

varMinDate <> vMinDate

Did you post the wrong error or code ?  Can you post your whole script ?

[#9]

Sales:

LOAD OrderID,

     ProductID,

     Product,

     CustomerID,

     EmployeeID,

     OrderDate,

     Margin,

     Sales,

     Cost,

     Quantity

FROM

C:\Users\PITCHAIAH\Desktop\Sales.xls

(biff, embedded labels, table is [Orders$]);

NoConcatenate

Sales1:

LOAD *

Resident Sales

Order By OrderDate;

DROP Table Sales;

LET vMinDate=Num(Peek('OrderDate',0,Sales1));

LET vMaxDate=Num(Peek('OrderDate',-1,'Sales1'));

TempCalendar:

Load

date($(vMinDate) + rowno() – 1) As TempDate

Autogenerate

$(vMaxDate) – $(vMinDate) + 1;

[JonnyPoole]

i noticed you never added the single quotes (around Sales1)  i mentioned in vMinDate definition. Can you try that  ?

LET vMinDate=Num(Peek('OrderDate',0,'Sales1'));

LET vMaxDate=Num(Peek('OrderDate',-1,'Sales1'));