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

                                          item_S_org_id

                          3. Customer-- Customer_p_org_id

                                                Customer_S_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.