Categories
- All Categories
- 99 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 55 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Isolate Data Flow Records that did NOT Join

Matt_B
Rank 2 - Community Beginner
The Join step within Data Flows should have the ability to show what records did NOT join.
For example:
A table that contains records from the L input that did NOT join to records from the R input.
A table that contains records from the R input that did NOT join to records from the L input.
Users often have requirements to isolate and modify certain data that did not join.
1
Comments
-
You should be able to do this using 'All rows' on both input and apply a filter to get either scenarios. So if you want to get records from L that do not have corresponding records in R, you need to apply a filter on one of the L's key columns where the value is NULL. The same logic can be applied to get records from R.
0