Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
What is the best way to connect a dimension missing in a table ?
LOAD:
Region
Year
Month
Sales
from Table1
LOAD
Channel
City
Country
Order
from Table2
Requirement is sum of Orders from Table2 must reflect by Region in Table1.
Do you have any table that links Regions to Channel/City?
No
I don´t see how we could link those tables if you don´t have a possible key to match records from one table to another
Do you have data that identifies what City & Country belong to which Region?
-Rob
Hi Rob,
Regions are only defined in table 1 as APAC, EMEA, LATAM, NA
While table 2 only has names of city + county.
So how would you know which rows of Table2 belong to which region? To resolve this, you will have to create a table that associates Countries to Regions.
-Rob
If you have not got the region vs. country look up data then you could probably download something from the web. A quick search found this https://docs.adjust.com/en/countries-by-region/
Obviously it depends on the exact formats you have for Country and Region in your data.