yes OK - but what if the home country and the car manufacturing
country are both important - i want to load the country table once and then join it to whereever i like/
I would suggest generating several key fields in the country table to tie to your various other tables.
load 'car_mfg'&country as car_mfg_country,
load 'car_mfg_&country as car_mfg_county,
notice you aren't trying to tie the country field from the car_mfg_table to the country field from the country_table.
U missd the point - Country is a key in both the tables - Home & Carmaker (see p.146 in the manual).
In adition - lets take the situation one step forward - now lets consider that i have a big table of countries, with many columns, such as flag image, and population, area in square meters, UN symbol, continent, and many more.
the Q is - how to load the table once but use its data twice, without affecting eac other.
I believe it has to do with some design pattern such as using QVD or whatever.
Does QlickTech members are monitoring this forum?
Thanks for responsing'
For the data model:
See page 146 in the manual and add one more table of countries.
For my Q:
I used to work few yesrs with microsoft SSAS and it was posible to load the countries table once and use its data as many times as you like, with the option to select CANDA as the Carmaker country and USA as the BuyerHome country.