calling orderdate into 2nd table from first table

[harleen_singh]

Hello,

          i am writing this code

        Load

       orderdate, A, B,C from table1

Load

if(IsNull(EndDate),max(orderdate),EndDate) as EndDate,

StartDate,

TerritoryID From

Table2

the above code gives error?? how to solve it?

thanks
Lavi

[harleen_singh · Accepted solution]

Lukasarn,

             i have done by creating Temporary table

Temp:

LOAD

num(max(OrderDate)) as MaxDate

Resident Table1;

LET vMaxDate = peek('MaxDate', 0, 'TEMP');

Drop Table Temp;

Now i can use this variable VMaxDate any where.

thanks for your kind help

Regards
Lavi