Single column multiple joins

[New-Qlik]

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.

[MK9885]

Look at below link and maybe use a join which suits your need?

Understanding Join, Keep and Concatenate

or if you can upload a sample data set?