3 Replies Latest reply: Jan 11, 2017 6:28 AM by Yeo Poh sai RSS

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

    Yeo Poh sai

      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