Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
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.