Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

left keep

Hi All,

What is the difference between left keep and left join?

Thanks.

1 Solution

Accepted Solutions
Not applicable
Author

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.!!!

View solution in original post

5 Replies
Not applicable
Author

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.!!!

Not applicable
Author

thnks a lot

rohan_mulay
Partner - Creator
Partner - Creator

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

       ];

screenshot.JPG.jpg

Please refer the attached QVW file.

Anonymous
Not applicable
Author

Thanks Rohan

can you also explain Rank function??

rohan_mulay
Partner - Creator
Partner - Creator

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..