Hello Everyone,Stucked on a task.

[#1]

Hello,

I want to use scripting like as

data:

LOAD

  PlannedProduction as PP,

  PlannedRecieves as PR,

  PreviousStockonHand,

  PreviousStockonHand+PlannedProduction+PlannedRecieves-Forecast as ProjectedStockOnHand

  Resident Table where PeriodId='1' ;

store data into E:\Poornima\forecastAnalysis\data.qvd(qvd);

drop Table data;

Table:

LOAD PP,

     PR,

     PreviousStockonHand,

     ProjectedStockOnHand

FROM

data.qvd

(qvd);

Concatenate

LOAD

  PlannedProduction as PP,

  PlannedRecieves as PR,

  ProjectedStockOnHand as PreviousStockonHand,

  PreviousStockonHand+PlannedProduction+PlannedRecieves-Forecast as ProjectedStockOnHand

  Resident Table where PeriodId='2' ;

where i want to store the ProjectedStockOnHand for period 1 in PreviousStockonHand for period 2 .. and then concatenate both the tables.

Showing Problem, is there any way to solve it?

Thanks in Advance and Regards.

[israrkhan]

REMEMBER, If you are using aggregate function in load or selct , then you have to group by all fields in load or select statment.

LOAD

         ProductId,

  PeriodId,

  sum(PlannedProduction) as PP,

  sum(PlannedRecieves) as PR,

  sum(PreviousStockonHand),

  (PreviousStockonHand+PlannedProduction+PlannedRecieves)-Forecast as ProjectedStockOnHand

  Resident Table where PeriodId='1'

Group by ProductId,PeriodId,PlannedProduction,PlannedRecieves,PreviousStockonHand ;