left keep

[#1]

Hi All,

What is the difference between left keep and left join?

Thanks.

[#2 · Accepted solution]

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

[#3]

thnks a lot

[rohan_mulay]

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]

Thanks Rohan

can you also explain Rank function??

[rohan_mulay]

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