Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

rennesia
New Contributor III

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

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

Try a

Daily_Data:

LOAD DISTINCT

     ....


edit: Please note that when you are using a table box object to examine your data, the object will only show DISTINCT combinations of values, duplicates won't show. But they might be actually in your records.


2 Replies
Highlighted
MVP
MVP

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

Try a

Daily_Data:

LOAD DISTINCT

     ....


edit: Please note that when you are using a table box object to examine your data, the object will only show DISTINCT combinations of values, duplicates won't show. But they might be actually in your records.


rennesia
New Contributor III

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

Thanks Swuehl,
An easy solution for a 'big' problem!

Community Browser