Just a question from a beginner in QlikView, that might sound trivial for specialist...sorry about this
In my source DB, I have a "customer" table, with 3 fields representing country codes (numeric 3 digits). One is the nationality, one is the domicile and the third one is risk county. I also have a table "country" with the country code, name, short name, currency, etc
When loading into a qlikview document (standalone personal version), I am wondering how I can match the three different codes to the same country table...
I have tried this code, which seem to work, but I am not sure this is the proper way to do that...
Select ... cty_dom_id, cty_nat_id, cty_rsk_id... from mycustomertable
Select cty_code as cty_dom_id, cty_code as cty_nat_id, cty_code as cty_rsk_id, cty_name, cty_currency,.. from mycountrytable
Any recommendation is welcome.
Thanks for your help, or for links to any documentation / tutorial talking about this issue.