Get Started with Redwood for Oracle Cloud HCM Begin Now
Burst multiple data sets using Excel
Summary:
Hi,
I have a requirement to send excel file with 5 different tabs via bursting. Currently I have 5 data sets (all 5 have different columns). I am aware of the excel split data into multiple tabs method:
XDO_SHEET_?
XDO_SHEET_NAME_?
However, this is not fulfilling my business requirement as the basis I'm splitting the data is using REASON column where I need to group some of the reasons into a single group. For example, Reasons: Hire, Inward Secondment should be grouped as "New Hire".
I have also tried linking the 5 data sets, but I'm getting duplicates.
Is there a way I can burst multiple data sets from one data model?
Tagged:
0