IN Which scenario you go for join and keep

[d_koti24]

IN Which scenario you go for join and keep?

[ashfaq_haseeb]

Hi,

Ceck this

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

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

Regards

ASHFAQ

[its_anandrjs]

Hi,

The main difference in this Join and Keep is when ever simple joins like

1. Join

2. Left Join

3. Right Join

4. Inner Join

5. Outer Join

This joins attempt the result is single table we get but when ever the Keep is used with JOINs, then the second table available associated connected to the table.

Ex:-

If simple join used

Table1:

LOAD * Inline

[ Key,A

1,A1

2,A2

3,A3 ];

Left Join(Table1)

Table2:

LOAD * Inline

[ Key,C

1,C1

2,C2

4,C4 ];

We get table like

And if use Keep with Keep join

Table1:

LOAD * Inline

[ Key,A

1,A1

2,A2

3,A3 ];

Left Keep(Table1)

Table2:

LOAD * Inline

[ Key,C

1,C1

2,C2

4,C4 ];

And we get

Regards

Anand

[d_koti24]

Hi Guys,

            i know the diff b/n join and keep,but my question is in which situation we go for join,and in which situation we for keep?

Regards,

koti