Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below code given by Henric Cronström :-
For each vFileName in FileList('(vRAWPath)\*.txt')
ARSummary:
LOAD left(FileBaseName(), 4) AS Report5_pay,
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
FROM "$(vFileName)" (ansi, fix, no labels, header is 0, record is line);
Next vFileName
it does not generate any error. The issue is it does not generate the Table. So i does not able get below field :-
cust_id
company_pay
curren
Does any one know where go wrong ?
Enclosed my QV raw data and QVW file.
Hope some one can advise me.
For do the test , pls unzip the file to C:\TEST folder and copy the file into this folder.
Paul
Without testing, won't you need to use
FileList('$(vRAWPath)\*.txt')
and define the variable before?
Without testing, won't you need to use
FileList('$(vRAWPath)\*.txt')
and define the variable before?
qvw file could not be opened, Section Access?
Hi Stefan
when i add $ onto my script , i shouted wow . it work , thank you very much. you and sunny and HIC and many other are the expert.
Paul