topic Re: KEEP and Join in QlikView

KEEP and Join

Anonymous — Tue, 27 Aug 2013 10:28:39 GMT

Hi Friends,

I am new to Qlikview,can any one please help on what is the main diffrence between Keep and join.

Regrads

SHAIK

CELAMBARASAN — Tue, 27 Aug 2013 10:39:57 GMT

Join Merges two tables in to one.

But Keep does the functionlaity as what join does and leaves the tables as it is.

Example:

Table1: has Field1 and Field 2

Table2: has Field2 and Field3

If you do the join between table1 and table2

Table1 has the fields : Field1, Field2, Field3

in case you do Keep then: Table structure won't change but only change happens to data.

Celambarasan

tresB — Tue, 27 Aug 2013 10:44:02 GMT

Hope you have gone through the manual. For basic understanding from manual see here .

For further knowledge PFA.

To answer as main difference : Join produces single table whereas, Keep keeps both the tables.

MayilVahanan — Tue, 27 Aug 2013 10:45:56 GMT

Please refer this