topic Re. :Re: Re. :How to use left keep in QlikView

How to use left keep

Mon, 21 Feb 2011 09:53:43 GMT

Hi,

I have the following scenario:

Table1:

Load * from A

Table2:

Load * from B

Concatenate

Load * from C

I want use left keep to join Table1 and Table2, how to achieve? It means I want Table1 left keep the Table2.

Anyone knows?

Thanks.

Re. :How to use left keep

martin59 — Mon, 21 Feb 2011 10:02:48 GMT

Hi, You can try this :

Table2:
Load * from B;
Concatenate
Load * from C;

LEFT KEEP (table2)
Load * from A ;

Hope that helps you

AW:How to use left keep

Mon, 21 Feb 2011 10:24:18 GMT

Hi Isaac,

a few days ago a build a little example application with left/right keep and left/right join. Please take a look at it. Promote/demote the "exit-tab" in the script and see whats happening.

HtH

Roland

Re. :How to use left keep

Mon, 21 Feb 2011 10:24:33 GMT

Hi,

LEFT KEEP (table2)

Load * from A ;

It means Table2 is at the left and A at the right, is that right?

I want to put A into left and Table2 into the right.

How to do?

Re. :Re: Re. :How to use left keep

martin59 — Wed, 23 Feb 2011 15:13:42 GMT

It means Table2 is at the left and A at the right, is that right?

Yes, that's right.

I want to put A into left and Table 2 into the right

You have to do

RIGHT KEEP (table2)
LOAD * from A;

Otherwise, you can load A in first and use Left Keep.

Re. :How to use left keep

martin59 — Wed, 23 Feb 2011 15:15:24 GMT

Look at this application, and maybe you'll understand better