Selective Load - Only lines with an ID existing in another Table

[#1]

Hello,

Given the following INPUT and OUTPUT sample, what is the right script to do it?

Thank you !

[crusader_]

Hello,

Try to use Where clause with Exists() function... Something like this:

Table1:

LOAD ID

     , Field1

from .....

Table2:

LOAD

     ID-Cusomer

     , Field2

     , Field3

From ....

Where Exists(ID-Customer,ID);

Hope this helps you.

Regards,

Andrei

[anbu1984]

Table1:

LOAD ID

    , Field1

from .....

Table2:

LOAD

    ID-Cusomer

    , Field2

    , Field3

From ....

Where Exists(ID,ID-Customer);

[crusader_]

Sorry for misprint.

Yes, of course Where Exists(ID,ID-Customer); is correct.

Thanks for correction.

Andrei