topic Re: left keep in QlikView

left keep

Tue, 24 Jan 2012 06:36:37 GMT

Hi All,

What is the difference between left keep and left join?

Thanks.

Tue, 24 Jan 2012 07:07:58 GMT

Hi,

Left Keep and Left join gives the same output.

The only difference is that Left Keep keeps the Table separate in Data Model, whereas Left join merges the Tables that are joined.

Hope this helps.!!!

Tue, 24 Jan 2012 07:25:38 GMT

thnks a lot

rohan_mulay — Mon, 12 May 2014 06:46:52 GMT

Consider an example:

Test1:

LOAD * INLINE [

ID,Salary,l1,l2

a,1,1,1

b,2,3,3

c,1,2,2

];

Test2:

Left keep (Test1)

Load * Inline [

ID,F3

a,2

a,3

a,4

b,1

];

Please refer the attached QVW file.

Anonymous — Wed, 25 Jun 2014 15:23:17 GMT

Thanks Rohan

can you also explain Rank function??

rohan_mulay — Thu, 26 Jun 2014 13:19:37 GMT

Hi Bhumika,

U work in the office which is right next to my office bulding... Finde some time in break and meet me .. I will explain u the rank function there..