why keep and why join

[#1]

why keep and why join

[MK_QSL]

Keep will load only those data which are matching between two tables (of course depends on Left Keep or Right Keep etc) but will not join the two tables...

While Join will simply join the two tables according to your choice... i.e. Left Join, Right Join, Outer Join

[#3]

tnk u

[its_anandrjs]

HI,

When this joins used we get single tables

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