7 Replies Latest reply: Apr 16, 2016 4:10 AM by Ridhaa Hendricks RSS

    Connecting to multiple excel sheet names

    Ridhaa Hendricks

      Hi There

       

      I have an issue loading data from excel.

      The excel document will be generated monthly , and the file name of the document will be named after the month.

      Sales20160131.xlsx

       

      I know I can deal with each file by loading * but how would I deal with the sheet names because that will change on each document as well?

       

      Your assistance is appreciated.

       

       

      LOAD

      Sales_Value,

      Product

       

       

      FROM
       
      $(vPath)\Sales_*.xlsx
      (
      ooxml, embedded labels, table is Sales_20160131);

       

      Regards,