Ashim Dutta

• Jul 10th, 2005

 

ashimdutta@yahoo.com 
If the user wants to group the records on particular field values then rollup is best way to do that. Rollup is a multi-stage transform function and it contains the following mandatory functions. 
1. initialise 
2. rollup 
3. finalise 
Also need to declare one temporary variable if you want to get counts of a particular group. 
 
For each of the group, first it does call the initialise function once, followed by rollup function calls for each of the records in the group and finally calls the finalise function once at the end of last rollup call. 

sangee

• Nov 29th, 2006

 

rollup summarize the group of data records.for eg: if we want the maximum value of the cust_id we will go for rollup.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jul 3rd, 2008

 

Rollup summarises the group of data records based on key eg you want the income of a particular city from a set of records , you can use the rollup component.

example 
dml is customer ,city name and amount (here the key is city name)

1|NY|200.00|
2|NY|222.00|
3|CA|333.00|
4|CA|400.00|

here you can you the rollup component to sum the amount for a particular city , the output of rollup is shown below.

NY|422.00|
CA|733.00|

Hope this helps.