Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 273 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Left Outer Join in FAW-OAC
Summary
I cannot see option to do a left outer join in OAC projects.
Content
Dear All,
I am trying to create a project from 2 data sources. One of them is the pre-build FAW subject area and 2nd is the excel file.
My requirement is to create left outer join in such a way that all data from Subject Area should appear but only matching rows from the excel file should extend.
Regards
Naeem
Answers
-
Naeem, you could do this using data sets.
- Create a data set with required columns from the FAW subject area and create a project of it.
- Add the second data set which could be from a different subject area or a spreadsheet
- Add the join between the two columns in the Data tab
- In the Visualize tab, modify the data blending options
Refer the two screenshots in the attached zip file, the first one displays records from both data sets
The second one displays the matching records from data set 2 with data set 1 I.e. Left outer Join
Data Set 1 here is coming from HCM FAW subject area
Data Set 2 is a spreadsheet- Raghu
1 -
Hello Raghavendra,
Please share the zip file, not able to find in this post. I am working on similar requirement.
0
