topic Re: what is difference between left and left keep join in qlikview in QlikView

what is difference between left and left keep join in qlikview

Wed, 24 Sep 2014 10:45:33 GMT

Please suggest

Re: what is difference between left and left keep join in qlikview

senpradip007 — Wed, 24 Sep 2014 10:59:12 GMT

The Join and Keep prefixes can be preceded by the prefix left.

If used before join it specifies that a left join should be used. The resulting table will only contain combinations of field values from the raw data tables where the linking field values are represented in the first table.

If used before keep, it specifies that the second raw data table should be reduced to its common intersection with the first table, before being stored in QlikView.

left( join | keep) [ (tablename ) ](loadstatement |selectstatement )

Examples:

Table1
A	B
1	aa
2	cc
3	ee

Table2
A	C
1	xx
4	yy

QVTable:

select * from table1;

left join select * from table2;

QVTable
A	B	C
1	aa	xx
2	cc
3	ee

QVTab1:

select * from Table1;

QVTab2:

left keep select * from Table2;

QVTab1
A	B
1	aa
2	cc
3	ee

QVTab2
A	C
1	xx

The two tables in the keep example are, of course, associated via A.

tab1:

Load * from file1.csv;

tab2:

load * from file2.csv;

.. .. ..

left keep (tab1) load * from file3.csv;

Re: what is difference between left and left keep join in qlikview

aveeeeeee7en — Wed, 24 Sep 2014 11:03:51 GMT

See this:

http://community.qlik.com/thread/39177

Regards

Av7eN

Re: what is difference between left and left keep join in qlikview

Anonymous — Wed, 24 Sep 2014 11:05:49 GMT

Concatenate,Left Join, Left Keep

Re: what is difference between left and left keep join in qlikview

ashfaq_haseeb — Wed, 24 Sep 2014 11:06:13 GMT

Hi,

Look at this too.

http://community.qlik.com/docs/DOC-6562

Regards

ASHFAQ

Re: what is difference between left and left keep join in qlikview

maxgro — Wed, 24 Sep 2014 11:09:30 GMT

from Qlikview en espanol

Re: what is difference between left and left keep join in qlikview

Wed, 24 Sep 2014 11:13:36 GMT

Thankssssss everyone for quick response,

Special thanks to Grossi

Re: what is difference between left and left keep join in qlikview

senpradip007 — Wed, 24 Sep 2014 11:39:43 GMT

If you get the desire result please close this thread.

Re: what is difference between left and left keep join in qlikview

Wed, 24 Sep 2014 11:48:05 GMT

how to close the thread , i m new to this blog

Re: what is difference between left and left keep join in qlikview

senpradip007 — Wed, 24 Sep 2014 12:09:50 GMT

Choose the correct answer as correct and helpful as helpful answer.