Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
louisernould
New Contributor III

condition Where crossing 2 tables

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

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted

Re: condition Where crossing 2 tables

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);

View solution in original post

7 Replies
Highlighted

Re: condition Where crossing 2 tables

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);

View solution in original post

Highlighted
louisernould
New Contributor III

Re: condition Where crossing 2 tables

Hi Sunny, 

It works, thank you !!! 🙂

 

Highlighted
somacdc
New Contributor III

Re: condition Where crossing 2 tables

and how to store above tables result into qvd?

Highlighted

Re: condition Where crossing 2 tables

By using Store statement

Store A into A.qvd (qvd);

Highlighted
somacdc
New Contributor III

Re: condition Where crossing 2 tables

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);

 

Highlighted

Re: condition Where crossing 2 tables

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

Highlighted
somacdc
New Contributor III

Re: condition Where crossing 2 tables

Thanks for your kind response. i resolved myself