Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?