Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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.
0