Aggr()

[NavinReddy]

Hi All,

Could some one help me

What is the purpose of AGGR and How it helps

Thanks In Advance

Niranjan

[#2]

Yup..i was referring to table box. In that case why would one use a table box? Straight table covers everything, so is there any functionality in table box which is not there in straight table or does it have any unique feature?

[Anonymous]

Straight table covers all features of table box.

Only difference is we have to essentially define an expression in straight table while theres no need of it in table box.

[#4]

Hi Niru,

Aggr() function is a Group by function like Oracle, you can group by each customer wise, product wise,product wise.

you can get use aggregate function like Min,Max,Avg.

For Ex,

LOAD * Inline [

Customer_ID,Year,Month,Sales

101,2013,Jan,55

102,2013,Jan,56

103,2013,Jan,57

101,2013,Feb,65

102,2013,Feb,66

103,2013,Feb,67

101,2013,Mar,77

102,2013,Mar,78

103,2013,Mar,79

];

In Expression are,

Sum(Sales).

Aggr(Sum(Sales),Year)

Aggr(Sum(Sales),Customer_ID)

Aggr(Sum(Sales),Year,Customer_ID)