topic Re: why keep and why join in QlikView

why keep and why join

Thu, 30 Oct 2014 16:32:14 GMT

why keep and why join

Re: why keep and why join

MK_QSL — Thu, 30 Oct 2014 16:34:11 GMT

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

Re: why keep and why join

Thu, 30 Oct 2014 16:38:57 GMT

tnk u

Re: why keep and why join

its_anandrjs — Thu, 30 Oct 2014 16:48:43 GMT

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