11 Replies Latest reply: Jan 12, 2017 5:25 AM by Yeo Poh sai RSS

    where to change the script , so it will load the file name i want QV to load ?

    Yeo Poh sai

      Hi All



      My below script work fine , May i know how to make it load only below 3 file ?




      Now it load all row data at C:\TEST , May i know how to modify the script ?





      SET vDevelopment = 30;



      IF $(vDevelopment) = 0 THEN



      ELSEIF $(vDevelopment) = 30 THEN



        SET vRAWPath = 'C:\TEST\'; //local folder


        set vFile1 = 'Q_Payment_KL';

        SET vFile2 = 'Q_Payment_Penang';

        SET vFile3 = 'Q_Payment_TID';





      END IF



      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); 

      Next vFileName


      Remark :- Pls unzip the file to C:\TEST for testing.