topic Re: Data script in QlikView

Data script

jduenyas — Tue, 17 Mar 2015 20:15:16 GMT

Hi all

I have a long running query from SQL to a table.

TABLE1:

Load

a, b, c;

SQL SELECT a, b, c

FROM T1;

I then need to query another table in SQL excluding records that exist in the long running query.

TABLE2:

Load

d, e;

SQL SELECT d, e

FROM T2 LEFT OUTER JOIN

T1 ON T1.A = T2.A

WHERE T1.A IS NULL

Since T1 is long running, and the data is already loaded from the first load statement, is it possible to use TABLE1 instead of calling again T1?

What should the JOIN be?

Thanks in advance

maxgro — Tue, 17 Mar 2015 20:34:21 GMT

you can't join a QlikView table (Table1, in memory) to a table in a database T2

you can join QlikView tables with QV tables

or database tables with .......

maybe this (check it)

TABLE1:

Load

a, b, c, a as a2;

SQL SELECT a, b, c

FROM T1;

TABLE2:

Load

d, e, a as a3

where not exists (a2, a);

SQL SELECT d, e, a

FROM T2;

drop field a2;

drop field a3;

jduenyas — Tue, 17 Mar 2015 20:41:06 GMT

Thanks. I will try your solution.

The main take away "...you can't join a QlikView table (Table1, in memory) to a table in a database T2..." was very important to know.

Thanks again.