what is the best way to reduce the file size ?

[paulyeo11]

Hi All

I have QVW file , i like to reduce the file size .

what i did is i remove the old data. That is my sales order table have sales from 1997 till 2017.

So what i do is to remove the 1997 till 2013 data. as those old data we don;t need to analyse.

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

//BRAND_='BECKHOFF';

  Year_n < 4;

DROP TABLES sales;

When i using the above script to remove those old data only keep last 4 year data.

Year_n = 1 is current sales

Year_n = 2 is last year sales

Above work fine , but it affect my sales target report.

Can some one advise me how to reduce the file size and not affect my report ?

Paul Yeo

[paulyeo11]

Hi Kushal

The link you give me on doc analysis. i think it is good tool.

I just try i get some error.

I will post my question on there.

Paul Yeo

[paulyeo11]

Hi Kushal

Document Analyzer V3.0 Update Available

I have post the error msg on the above link.

As i still unable to use the Doc Analyzer.

Paul