Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Matching several codes to the same table

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

2 Replies
Not applicable

Matching several codes to the same table

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.

Not applicable

Matching several codes to the same table

Hello Nick,

Thanks for the answer...Appreciated.

Regards

Daniel

Community Browser