Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 245 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 91 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Full outer join while blending data
vkm
Rank 5 - Community Champion
Summary
Full outer join while blending data
Content
Hello,
Is it possible to have Full outer join when blending 2 datasets in a project in DAta Diagram view?
Thanks,
VAishali
0
Answers
-
Happy New Year!
It is not possible to do a full outer join in the data diagram... just add facts or extend dimension. Your best way to do a full outer join would be to create a Data Flow. Within the data flow you have the most flexibility to join, merge and/or branch your data sets to give you exactly what you need. These can also be scheduled and run in a sequence of multiple data flows.
Brian
0