We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
21
Views
10
Comments
edited Jun 17, 2021 6:04PM in HCM Integrations 10 comments

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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!