topic Trick to Reduce QVW File Size in QlikView

Trick to Reduce QVW File Size

Wed, 26 May 2010 15:04:59 GMT

Initially I loaded a huge table using the following code

Load F1,

F2,

F3,

FROM TABLE1.QVD;

The Above code created a qvw file with 230 MB file size.

The same table I created using a join

LOAD F1,

F2,

FROM TABLE1.QVD;

LEFT JOIN

LOAD F1,

F2,

FROM TABLE1.QVD;

This created a qvw file size of 150 MB, both of them had the same Data & same no of rows.

Does any one has explaination , how did this happen?

Thu, 27 May 2010 04:28:29 GMT

Hi Abdul,

Instead of Left Join, try to use "Apply Map". Create a unique key between 2 tables and look up the 2nd table to get the desired value.

Always left join will increase the file size.

Regards

Rajesh

Thu, 27 May 2010 05:27:28 GMT

You are right,

I was not joining them properly, that is why the file size got reduced.

Joining does not decrease the file size.

Thanks,

Abdul