How to make my load script on reduce the data for keep last 3 year data and not remove my field name = Exp ?

[paulyeo11]

Hi All

I have a issue of my QVW file more then 20 mB , when i convert to QVF , i am not allow to transfer to QVF file to cloud. in order to remove some of the data from my QVW file , i using the below 2 script :-

!. Script below will keep last 3 year data but it will remove Exp field. ( May i know how to prevent it remove the Exp field ? )

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

  Year_n > 10;

DROP TABLES sales;

2. Script below work fine. it can keep last 3 year data , But does not remove a lot of data. file name still more then 20 mB.

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT MasterCalendar WHERE

  year > 2010;

DROP TABLES MasterCalendar;

My question is how to remove those year before 2015 and keep only last 3 year data and not remove the field name Exp ?

Paul Yeo

[paulyeo11]

My QV Doc

[prma7799 · Accepted solution]

Try this

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT MasterCalendar WHERE

  year > 2015;

DROP TABLES MasterCalendar;

Load * from ABC;

drop Field Exp ;