Hi, am not able to implement SUM() in resident load..?

[#1]

Hi All,

Please help me in this..

[alexandros17]

If you use sum you must use group  by clause ....

[MK_QSL]

Temp:

Load

     Customer,

     Sales

From TableName;

NoConcatenate
Final:

Load

     Customer,

     SUM(Sales) as TotalSales

Resident Temp

Group By Customer;

Drop table Temp;

[#4]

Hi thnx for reply,

Yes i have used group by clause also..

[#5]

Hi All,

Thanx for your replies,

may be my question is not very clear i believe.

am creating one NEW_TABLE by using multiple RESIDENT LOADS.

i have used 4 resident loads, in the creation of NEW_TABLE I have already used Group by clause on one sum() function.

i am facing problem in implementing one AGGR() function..

is there any limitation in sing AGR() in resident load..?

[senpradip007]

Could you please upload sample qvw?