Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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