2 Replies Latest reply: May 20, 2016 8:10 AM by Automation - RSS

    Why does JOIN results in a correct table, but in a large QVD file?

    Automation -

      I have to collect data from several tables for the registered hours and combine them in one table.

      When I combine several loads with a left join, the resulting table in QlikView is OK, but when I inspect the QVD-file, the table data is stored 'unjoined'. In the example below I use a small database, but in real I have lots more of data, resulting in a very large QVD-file.

      How can I optimize the script to make a smaller QVD-file?

       

      Data in SQL-database:

      sql-data.png

      Script:

      script.png

      Resulting table in QlikView:

      qv-table.png

      Data in Dailydata.QVD:

      qvd-data.png