condition Where crossing 2 tables

[louisernould]

Hi the Qlik Community, 

I've got a problem about the Where Condition, but I don't know if Qlik is capable to do what I want...

In my script, I want to select in a where condition, only the dimensions existing in a different table (I loaded it just before). I want it because one of the table is really huge (50 milions of lines), so it's too long to load it.

So, I cannot load the first table, then the second one, then join then.

My 2 tables come from a server.

I want to do this : 

Table A :

Load reference,
          reference as Ref,
          supplier
from ....
where supplier = 123;

left join (Table A)
LOAD reference,
             sales
FROM ....
where reference exist in (Ref);

If anyone could help, or if it's not possible, let me know 🙂 

thanks !

Louis

[sunny_talwar · Accepted solution]

Try this

Table A :
LOAD reference,
           reference as Ref,
           supplier
FROM....
Where supplier = 123;

Left Join (Table A)
LOAD reference,
             sales
FROM ....
Where Exists(reference);

[louisernould]

Hi Sunny, 

It works, thank you !!! 🙂

[somacdc]

and how to store above tables result into qvd?

[sunny_talwar]

By using Store statement

Store A into A.qvd (qvd);

[somacdc]

By using following store statement, before left join statement data is stored. But I want to store the whole result.

Table A :
LOAD reference,
           reference as Ref,
           supplier
FROM....
Where supplier = 123;

Left Join (Table A)
LOAD reference,
             sales
FROM ....
Where Exists(reference);
Store Table A into A.qvd (qvd);

[sunny_talwar]

Can you share an example of this script with some data?

[somacdc]

Thanks for your kind response. i resolved myself