topic condition Where crossing 2 tables in QlikView

condition Where crossing 2 tables

louisernould — Sat, 16 Nov 2024 04:49:22 GMT

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

Re: condition Where crossing 2 tables

sunny_talwar — Tue, 08 Jan 2019 17:33:57 GMT

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

Re: condition Where crossing 2 tables

louisernould — Wed, 09 Jan 2019 15:13:50 GMT

Hi Sunny,

It works, thank you !!! 🙂

Re: condition Where crossing 2 tables

somacdc — Mon, 05 Aug 2019 07:36:01 GMT

and how to store above tables result into qvd?

Re: condition Where crossing 2 tables

sunny_talwar — Mon, 05 Aug 2019 11:27:39 GMT

By using Store statement

Store A into A.qvd (qvd);

Re: condition Where crossing 2 tables

somacdc — Tue, 06 Aug 2019 05:29:12 GMT

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

Re: condition Where crossing 2 tables

sunny_talwar — Tue, 06 Aug 2019 11:13:40 GMT

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

Re: condition Where crossing 2 tables

somacdc — Fri, 09 Aug 2019 04:41:31 GMT

Thanks for your kind response. i resolved myself