Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

Henric Cronström give me a script after reload it does not create the table.

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Henric Cronström give me a script after reload it does not create the table.

Without testing, won't you need to use

FileList('$(vRAWPath)\*.txt')


and define the variable before?


3 Replies
MVP
MVP

Re: Henric Cronström give me a script after reload it does not create the table.

Without testing, won't you need to use

FileList('$(vRAWPath)\*.txt')


and define the variable before?


stabben23
Honored Contributor

Re: Henric Cronström give me a script after reload it does not create the table.

qvw file could not be opened, Section Access?

paulyeo11
Valued Contributor II

Re: Henric Cronström give me a script after reload it does not create the table.

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

Community Browser