This content has been marked as final. Show 2 replies
I like to start a new thread , as this will benefit other people who may have similar requirement,
Mr Staffan have help me modify the script , now my raw data file name can be edit at excel file , and user don't need to touch on the QVW load script.
I like the field name , to enter from excel ? So that i can decide how many field i want to load. For example now i loading 4 field :-
FileBaseName() as SOURCE,
@1:9T as [cust_id],
@10:38T as [company_pay],
if(right(@81:99T,1)='-', '-' & left(@81:99T, len(@81:99T)-1),@81:99T) as curren
FileBaseName() as vFile1d1,
@1:9T as [vFiled2],
@10:38T as [vFiled3],
if(right(@81:99T,1)='-', '-' & left(@81:99T, len(@81:99T)-1),@81:99T) as vFiled4
And i am allow to tick or set how many field i want to load. ( Let raw data file i can load 1 to 4 by change the NoOfRows )
So when development i can load more field , and after production i only load those field need. And i don't need to modify the script.
Hope Some one can share with me.