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.
Repeating Rows
Summary:
I am creating a report that will show job requisitions, the candidates who applied along with their education and previous employment information. Due to multiple records of education and employment, if a candidate has more education than employment records, the employment record is duplicated and vice versa. How can I present this data such that employment and education info are compressed into each candidate's line of record? The report is quite wide so I am not sure a pivot table can help. I have attached the logical sql code. Thanks.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Tagged:
0