Matching several codes to the same table

Fri, 27 Aug 2010 13:34:21 GMT

Hello,

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

and

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.

Daniel

Matching several codes to the same table

Fri, 27 Aug 2010 15:30:38 GMT

There are two options:

1) load Country table 3 times for each type of code

2) create 3 fields in Country table for a code with respective field names from Customer table.

Matching several codes to the same table

Fri, 27 Aug 2010 15:46:37 GMT

Hello Nick,

Thanks for the answer...Appreciated.

Regards

Daniel

topic Matching several codes to the same table in QlikView

Matching several codes to the same table

Matching several codes to the same table

Matching several codes to the same table