General OBIEE

Get Involved. Join the Conversation.

Topic

    Divya Joy
    How to combine results from two Analysis
    Topic posted July 13, 2018 by Divya JoyBlue Ribbon: 750+ Points 
    485 Views, 3 Comments
    Title:
    How to combine results from two Analysis
    Summary:
    How to combine results from two Analysis
    Content:

    Hi All,

    I have to combine the results of two analysis into one.

    Please find the details of input Analysis A and Analysis B below.

    The expected results are also mentioned, can you please guide me?

     Please note that the number of "subjects" are fixed.

    Analysis A              
    Stud No Stud Name Address Country  Class      
    123 Jack Jack Add India 3      
    124 Eli Eli Add USA 3      
    125 Mack Mack Add AUS 4      
                   
    Analysis B              
    Stud No Subject Mark          
    123 Match 60          
    123 Science 70          
    123 Social 80          
    124 Science 99          
    125 Match 30          
                   
    Output              
    Stud No Stud Name Address Country  Class Match Science Social
    123 Jack Jack Add India 3 60 70 80
    124 Eli Eli Add USA 3   99  
    125 Mack Mack Add AUS 4 30    

     

    Comment