3 Replies Latest reply: Apr 3, 2017 11:07 AM by Aar Kay RSS

    Joining 2 Fact tables on multiple keys based on Condition

    Abhay Sudhakaran

      Solution: (Conditional Join)

      Link Table 1 (Key1) to Table 2 (Key1) if they exist

      Else link Table 1 (Key2) to Table 2 (Key2)

      Else "NULL".

       

      How do i approach this solution, and build the linking key ?

       

      Any help is appreciated.

       

      Thanks,