Oracle Fusion Data Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Isolate Data Flow Records that did NOT Join

15
Views
1
Comments

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
1 votes

Submitted · Last Updated

Comments

  • Syaifuddin Ismail-Oracle
    Syaifuddin Ismail-Oracle Rank 1 - Community Starter

    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.