How to use left keep

[#1]

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.

[martin59]

Hi, You can try this :

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

LEFT KEEP (table2)
Load * from A ;

Hope that helps you

[#3]

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

[#4]

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?

[martin59]

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.

[martin59]

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