Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to Show Two Columns As One
I have a report in OTBI that uses the Workforce Management - Processed Time Cards Real Time subject area. Two fields are included in the query, Absence Type and Hours Type, along with Processed Hours. What is happening is the output shows the Absence Type in one column and the other Hours Type in a separate column, and the hours for each are in one column. I would like to show both the Absence Type and Hours Type result values in one column. Here is a sample of the output attached and below it how I want it to show.
How it currently shows | |||||
|---|---|---|---|---|---|
PP Start Date | PP End Date | Job Name | Absence Type | Hours Type | Hours |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech | On Call | 19 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech | Holiday US | 8 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech-2nd 6 mo | Doubletime 2_0 Premium | 3 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech-2nd 6 mo | Doubletime 2_0 Straight | 3 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech-2nd 6 mo | Regular Pay | 72 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech-2nd 6 mo | Holiday US | 8 | |
How I want it to show | |||||
PP Start Date | PP End Date | Job Name | Hours Type | Hours | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech | On Call | 19 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech | Holiday US | 8 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech-2nd 6 mo | Doubletime 2_0 Premium | 3 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech-2nd 6 mo | Doubletime 2_0 Straight | 3 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech-2nd 6 mo | Regular Pay | 72 | |
11/03/24 | 11/16/24 | Sr LNG and Propane Tech-2nd 6 mo | Holiday US | 8 | |
Best Answer
-
Just remove other two and keep only the concatenated one.
2
Answers
-
Can you try below?
Add a field to the report > Field Settings > Edit Formula. Edit the formula and use concat function to concatenate the columns:
CONCAT("Processed Time Entry Details"."Payroll Time Type Name","Expenditure Type"."Resource Type Name")
Set the column header from Column properties:
Thanks.
1 -
Unfortunately, that does not solve the issue. Using exactly what you indicated, it did combine some data, but the second portion of the data is not any I am using. I did try the same by concatenating The Absence Type Name with the Payroll Type Name, but that does not actually cause all of the element names to be in one column. I need a way to ensure the Absence and Non Absence element names are in one column and the hours are in one column as my second example shows. I think someone said you have to use filters, but I do not know the actual steps to make that happen.
0 -
Can you paste a screen shot of what you see after using CONCAT?
Thanks.
0 -
0 -
I can see data is coming as expected in Test column. What is the expectation?
Thanks.
0 -
The element names, whether Absence or Non Absence, should be in a single column not in two separate columns
0 -
As you can see, Absence Type is a separate field from the Hours Type. It does not appear there is a single field that will capture both absence and non absence element names so you have to have both of these, but I want it to only show in one column for the description.
0 -
Oh my goodness, it is a Monday. Yes, I think that will work. My apologies!
0