topic Re: keep join. in QlikView

keep join.

Tue, 11 Nov 2014 07:37:26 GMT

how we can differentiate the keep join...

Re: keep join.

ashfaq_haseeb — Tue, 11 Nov 2014 07:40:01 GMT

Hi,

Check this

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

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

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

Regards

ASHFAQ

Re: keep join.

Tue, 11 Nov 2014 07:49:20 GMT

Thanks.

Re: keep join.

MK_QSL — Tue, 11 Nov 2014 07:51:14 GMT

KEEP

Sales:

Load * Inline

[

Customer, Sales

A, 100

B, 200

C, 120

];

Left Keep(Sales)

Customer:

Load * Inline

[

Customer, Name

A, AAA

B, BBB

C, CCC

D, DDD

];

Due to Left Keep, the second table (Customer) will load only those Customers which are having Sales from Sales Table.

Also, Keep will not join the two tables, but both table will be separate and associated with each other by Customer Field

If you use Left Join (Sales) instead of Left Keep (Sales), now the result is same for 2nd Table,,, i.e. only those customers would be loaded whoever are having sales from Sales Table but here both table are now joined and only Sales table exist at the end of the script..

Re: keep join.

ashfaq_haseeb — Tue, 11 Nov 2014 07:51:38 GMT

HI,

if it answered, then please close this thread.

Regards

ASHFAQ

Re: keep join.

Nagaraju_KCS — Tue, 11 Nov 2014 07:58:16 GMT

Hi Hammad ,

Join: Join will combine the rows where the key values matches..

table1: table2:

ID name ID Sal

1 ABC 1 10000

2 CBD 3 20000

left join Output:

ID Name sal

1 ABC 10000

2 CBD -

3 - 20000

Keep: Keep must prefixes with inner, left and Right keep

Left keep Output:

Table1: Table2

ID Name ID Sal

1 ABC 1 10000

2 CBD

Hope it helps...............

Re: keep join.

Tue, 11 Nov 2014 08:01:16 GMT

thanks it helps me.how to close the thread.

Re: keep join.

MK_QSL — Tue, 11 Nov 2014 08:02:29 GMT

Select Correct / Helpful answer from the answers given by members..

You can only select one Correct and Maximum Two helpful answers...

Re: keep join.

ashfaq_haseeb — Tue, 11 Nov 2014 08:03:31 GMT

Open this thread in new window,

You will find an option to mark it as correct and helpful.

Regards

ASHFAQ