Categories
- All Categories
- Oracle Analytics Learning Hub
- 33 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 97 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Need help on why my data has mutiple rows and how to work around it
I am a supplier registration request analysis and have created a measure colomn for the number of pending approval request. However, there a mutiple rows for the mesaure for a single request number. can you guie how to change this so there is one row for each request number
Answers
-
Hi @User_0E6OZ,
Welcome to the Oracle Analytics Community!
Could you please share more information, such as a screenshot of the issue (without sensitive data), a brief explanation of the problem, and the report catalog or XML?
This will help us better understand the issue and identify a possible resolution.
Thank you.
0 -
Please see screenshot of the table
0 -
the request number 1681020, has two rows in the # pending approval coloumn. I want there to be one row in the #pending approval colomn per request number
@Bhaskar Konar Can you please help guide? The screenshot to the tbale is
0 -
Hi @User_0E6OZ,
Thanks for the details.
Looking at the screenshot, it seems there are 2 'Category Name' for Request Number: 1681020, as result 2 rows are coming.
If you take out the column 'Category Name' from the report, the Request Number: 1681020 should return only 1 row.
Hope this help.
Thank you.
0 -
Thank you @Bhaskar Konar it work if i remove that column.
But what if i dont want to remove the column category name. How to resolve it then? I want to create a graph for the supplier per category as well.
0 -
Hi @User_0E6OZ,
That's good news.
Quick Question for you: Is it possible functionally: for a particular Request Number (1681020) can be associated with 2 different Categories? Wanted to make sure the data are correct.
0 -
Yes thats is correct. A request number can be associated with multiple categories.
0 -
Thank you! That's good news.
If you present it via graph what issue are you getting?
0
