This content has been marked as final. Show 2 replies
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:
Resulting table in QlikView:
Data in Dailydata.QVD: