Data script

[jduenyas]

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 · Accepted solution]

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]

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.