Discussion Board for collaboration on QlikView Scripting.
Below code given by Henric Cronström :-
For each vFileName in FileList('(vRAWPath)\*.txt')
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);
it does not generate any error. The issue is it does not generate the Table. So i does not able get below field :-
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.
Go to Solution.
Without testing, won't you need to use
and define the variable before?
qvw file could not be opened, Section Access?
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.