Forum Discussion

powerbiastra1's avatar
powerbiastra1
Frequent Visitor
3 years ago

Bring together 2 tables

I have two tables with data as below   as you can see columns pp and comm combination is matching only for one value   so how do I bring these 2 tables together ? A simple full outer join in orac...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi powerbiastra1，

 

Would you consider publishing the final expected output of tables that merged together?

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

powerbiastra1's avatar
powerbiastra1
Frequent Visitor
3 years ago

Unfortunately my user is not able to  give me that info, so I came up with above sample tables

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi powerbiastra1 ,

     

    What I want is the output after combining the above two sample tables. Would you tell me what its results look like? Take a screenshot in excel as well.🙂 thanks.

     

    Best Regards,
    Gao
    Community Support Team