Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

Hello,

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

Thank you !

Capture.PNG

3 Replies
crusader_
Valued Contributor

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

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
Honored Contributor III

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

Table1:

LOAD ID

    , Field1

from .....

Table2:

LOAD

    ID-Cusomer

    , Field2

    , Field3

From ....

Where Exists(ID,ID-Customer);

crusader_
Valued Contributor

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

Sorry for misprint.

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

Thanks for correction.

Andrei

Community Browser