Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator II
Creator II

Single column multiple joins

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.

1 Reply
MK9885
Master II
Master II

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?