topic Best way to pull data in from the same table in QlikView

Best way to pull data in from the same table

qliknerd — Thu, 11 Jul 2013 13:40:59 GMT

Hi there

I have a question on what the best way to pull data into QV is. I have 4 tables I need to bring in, e.g. 2 of them are common and 2 unique:

At the moment I am pulling the data in via OLDDB queries.

A number of queries reuse the same SQL.

Currently, I left join to other tables to get the data I need.

To reduce the calls on the db, is there an easier way to do this? I would like to run the queries for Table2_tmp and Table3_tmp once, and left join when I need them.

Any help/advice gratefully received!

Table1_tmp: 
SQL SELECT * FROM Table1;
LEFT JOIN (Table1_tmp)
Table2_tmp:
SQL SELECT * FROM Table2;
LEFT JOIN (Table1_tmp)
Table3_tmp:
SQL SELECT * FROM Table3;
MASTER:
LOAD *
RESIDENT Table1_tmp;
DROP TABLE Table1_tmp;
Table4_tmp: 
SQL SELECT * FROM Table4;
LEFT JOIN (Table1_tmp)
Table2_tmp:
SQL SELECT * FROM Table2;
LEFT JOIN (Table1_tmp)
Table3_tmp:
SQL SELECT * FROM Table3;
CONCATENATE (MASTER)
LOAD *
RESIDENT Table4_tmp;
DROP TABLE Table4_tmp;

Re: Best way to pull data in from the same table

swuehl — Thu, 11 Jul 2013 14:16:12 GMT

Have you considered using a QVD layer? That means, query your DB to retrieve table1 to table4, storing each in a qvd and then load the QVDs for your JOINs?

Re: Best way to pull data in from the same table

Sun, 27 Jul 2014 15:22:21 GMT

Use QVD's or Resident Load instead of direct data base loading

Re: Best way to pull data in from the same table

qliknerd — Mon, 28 Jul 2014 07:38:04 GMT

Thanks, I have seen the light and am intending to move to a 3-tier architecture. The more I develop and use QlikView, the better it gets 😉