2 Replies Latest reply: May 3, 2016 9:08 AM by Paulo Lindoso RSS

    How to "outer keep" a table?

    Paulo Lindoso

      Hello All,

       

      I am still a newbie to Qlik, so please bear with my stupid questions.

       

      I have two tables (TABLE1 and TABLE2) that coming from 2 different data sources that can be linked by one key.  TABLE2 is a super set of TABLE1, ie all keys in TABLE1 will be found in TABLE2, but TABLE2 contains more keys than TABLE1.

       

      What I want to do is to load them, join by this key and keep them in two separate tables within Qlik.  From what I have read in Qlik's reference manual, what I need is an "OUTER KEEP", but that doesn't seem to be allowed.

       

      Graphically:

      TABLE1:

       

      KeyField1Field2
      1aabb
      2ddee

       

      TABLE2:

      KeyField
      1hh
      2kk
      3ll
      4oo
      5pp

       

      I need both tables loaded (IN FULL), linked by key, but separated.

       

      Is this possible?

       

      Kind regards