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.
I need both tables loaded (IN FULL), linked by key, but separated.
(html, codepage is 1252, embedded labels, table is @2);
or are you just looking to have a connection between the two (and not include the extra ids?) If that is the goal, you don't need to do anything. Just load them and the connection will be automatically formed because they are named the same.