BI Publisher (MOSC)

MOSC Banner

How to accomplish outer join between two datasets in BI Publisher

edited Apr 27, 2017 5:00AM in BI Publisher (MOSC) 2 commentsAnswered

Example : 

     Datasource : A                          Datasource : B 

     DataSet 1  : EMPLID                DataSet 2 : EMPLID

                         1                                               3

                         2                                               4

                         3                                               5

                         4

                         5

                         6

    Question : How to create a report that looks like

     

         EMPLID_Set1           EMPLID_Set2

          1

          2   

          3                               3

          4                               4

          5                               5

          6

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center