Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
OTBI - separate value into two columns
Summary:
OTBI - separate value into two columns
Content (please ensure you mask any confidential information):
I am creating an OTBI analysis report and I want to separate the value from one column into two columns; essentially the text to column feature within Excel and how to complete within OTBI.
In the provided example below, I have included a fictitious value for the field Department Name. What I would like to do is have the numerical value (HBU#) in one column and the department name (text portion) in another column. Please advise if there is a way to complete this task.
Tagged:
0