2 Replies Latest reply: Aug 27, 2010 11:46 AM by Daniel1964 RSS

    Matching several codes to the same table

    Daniel1964

      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