1 Reply Latest reply: Aug 29, 2018 8:17 AM by Shahbaz Khan Mohammed RSS

    Single column multiple joins

    avneet taneja

      Hello everyone


      I  have three dim tables .

                          1. organissation-- org_id(key)

                          2.item -- item_P_org_id


                          3. Customer-- Customer_p_org_id




      now I want to join items both org_ids with organization's org id and similarly for customer 's org_ids with organization\s org_id.


      how do I do that as I cannot concatenate item_P_org_id and item_S_org_id it has to be seprate columns only.



      Kindly Guide.