This content has been marked as final. Show 2 replies
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...
... cty_dom_id, cty_nat_id, cty_rsk_id...
cty_code as cty_dom_id,
cty_code as cty_nat_id,
cty_code as cty_rsk_id,
Any recommendation is welcome.
Thanks for your help, or for links to any documentation / tutorial talking about this issue.