6 Replies Latest reply: Jan 11, 2017 6:35 AM by PAUL YEO RSS

    May i know how to make use of Loop command and load 100 raw data set ?

    PAUL YEO

      Hi All

       

       

      I have 100 company raw data.

       

       

      Each of the company i need to load the below script :-

       

       

      ARSummary:

       

       

      LOAD left(FileBaseName(), 4) AS Report5_pay,

       

       

        'company_1' as SOURCE,       // This will help to filter company_1 to company_100

       

       

        @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 $(vRAWPath)$(vFile1) (ansi, fix, no labels, header is 0, record is line);     // File1 refer to company_1 raw data till file100 refer to company_100

       

       

      Instead of i need to repear write the script 100 time. May i know how to make use of Loop command and load 100 raw data set ?

       

       

      This will make maintenance easy.

       

       

      Hope some one can advise me how to do it ?

       

       

      Paul