Im calling a sub after setting a variable's value . According to this value it should perform either a load from qvd and then concatenate records or only perform a normale load. As a OO programmer just copying (99 % same) code to solve this issue is not an option.
My pseudo code reads:
Receipts:
If $CurrentYear = ‘2012’ then {
LOAD * FROM [$(vpath.QVDTarget)Metacom_WeegBonnen.qvd] (qvd);
Concatenate LOAD }
Else
Load
Field1 As Field_1,
… ;
(in Total 45 fields, whom some are skipped and others are calculated in both ‘runs’ )
SQL SELECT *
FROM $(vpath.DBs)Receipt$(CurrentYear);
Store Receipts into Receipts.qvd (qvd)
After setting the var $CurrentYear to 2011 it should just load records and store them to a qvd. The second call when variable is set to 2012 this qvd should at first be loaded and remaining records should then be concatenated. Just always loading the qvd is not an option as any 'old data' stored in a qvd should be replaced during a 'reload' .
Please advice me in configuring the bold part of this pseudo coding into a script. Please pay no attention to any syntax errord in my current example.
Thanks in advance
