Transformation fast formula -- Combining multiple rows from input file into one row

Summary

Transformation fast formula -- Combining multiple rows from input file into one row.

Content

Hi, 

Is there a way to combine multiple rows of data into one row in HDL transformation fast formula. 

Here is the requirement that i have. 

Source file 

Emp      Absence balance    Absence Type 

1            10                           Vacation

2             20                          Vacation 

I want to load the above in HCM as follows 

Emp  Absence balance  Abence type 

1           30 (10+20)         VAcation 

The reason behind combining the row in HCM is because the third party system is storing the values against multiple person number. But it is the same person. So in HCM we need to have it summed up and get it loaded against the Oracle person number.