7 Replies Latest reply: Jun 9, 2014 11:34 PM by PAUL YEO RSS

    How to combine 3 similar set of script into 1 ?

    PAUL YEO

      Hi All

       

       

      I have 3 set of completely similar script , only different is the Excel Sheet Name . May i know how to convert 3 of them into 1 for easy maintenance ?

       

       

      PRICE:

       

       

      LOAD

           BRAND_P,

           Model as PART_NO_,

           Description,

           [PRODUCT_LINE] as [PRODUCT_TYPE],

           [PRODUCT_LINE],

           Supplier,

           [Product Group],

           [LOCAL PRODUCT],

           Currency_P,

           date([Updated]) as Updated,

           Price as LIST,

           Price as LIST_PRICE

          

               

      FROM

      [$(vRAWPath)$(vFILE1)]

      (biff, embedded labels, table is SHEET1$);

       

       

       

       

      LOAD

           BRAND_P,

           Model as PART_NO_,

           Description,

           [PRODUCT_LINE] as [PRODUCT_TYPE],

           [PRODUCT_LINE],

           Supplier,

           [Product Group],

           [LOCAL PRODUCT],

           Currency_P,

           date([Updated]) as Updated,

           Price as LIST,

           Price as LIST_PRICE

          

               

      FROM

      [$(vRAWPath)$(vFILE1)]

      (biff, embedded labels, table is SHEET2$);

       

       

      LOAD

           BRAND_P,

           Model as PART_NO_,

           Description,

           [PRODUCT_LINE] as [PRODUCT_TYPE],

           [PRODUCT_LINE],

           Supplier,

           [Product Group],

           [LOCAL PRODUCT],

           Currency_P,

           date([Updated]) as Updated,

           Price as LIST,

           Price as LIST_PRICE

          

               

      FROM

      [$(vRAWPath)$(vFILE1)]

      (biff, embedded labels, table is SHEET3$);