How to reduce a file size from year > 2000

[paulyeo11]

Hi All

I have a QVW file , now the file size is 26 mb , I want to reduce to 20 Mb .

from my data model , i notice that there are many table , i want to focus on sales table ,

So i like to filter my Table = sales , and filter those data year > 2000

Hope some one can share with me the load script.

Paul Yeo

[paulyeo11]

enclosed my QVW

[Anil_Babu_Samineni]

May be use this in your table

SalesTable:

Load * from <Sales Table> Where year > 2000;

[paulyeo11]

Hi Anil

Thank you very much for your fast reply.

My table is sales , so i change your script to :-

Sales:

Load * from <sales> Where year > 2000;

I get the below error :-

Cannot open file 'C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\<sales> Where year > 2000'

Sales:

Load * from <sales> Where year > 2000

Where i go wrong ?

Paul Yeo

[Anil_Babu_Samineni]

check whether this path has the Sales table?

C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\<sales>

[paulyeo11]

Hi Anil

The folder you indicate does not have the sales table. Only have QVW file.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[Anil_Babu_Samineni]

But, Where you want to filter? I meant which Table you want to apply where clause?

[paulyeo11]

I want to add script at end of the QVW file to do the filter.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[prma7799]

You need to add this filter end of table ..

Like

Load * from

ABC

Where Year > 2000;

Or please mention Table name which you want to filter with year

[Anil_Babu_Samineni]

Can you help us to get tab name which has Sales Table? Then we can connect like

Assume, If you have 20 Tabs. In that 20 tabs the sales table in 13th Tab. In that last we have to add like

Sales:

Load * From SalesTable;

Left Join (Sales)

Load * From SalesTable Where year > 2000;