Transformation fast formula -- Combining multiple rows from input file into one row
SummaryTransformation fast formula -- Combining multiple rows from input file into one row.
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.
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.