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

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

Wed, 20 May 2015 08:00:55 GMT

Hello,

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

Thank you !

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

crusader_ — Wed, 20 May 2015 08:26:08 GMT

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

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

anbu1984 — Wed, 20 May 2015 09:16:45 GMT

Table1:

LOAD ID

, Field1

from .....

Table2:

LOAD

ID-Cusomer

, Field2

, Field3

From ....

Where Exists(ID,ID-Customer);

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

crusader_ — Wed, 20 May 2015 09:23:55 GMT

Sorry for misprint.

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

Thanks for correction.

Andrei