9 Replies Latest reply: Jul 17, 2015 8:28 PM by jagan mohan rao appala RSS

    Loading from Multiple excel files

      Dear Experts,

       

               I would like to ask you for multiple loading excel files. I have daily downloaded data and I would like to load these data by each date by writing scripts. While I am using filename() funtion and it shows the error.   Here is my script and error message in attached file.I am looking forward your help.

       

      Daily_Tr:

      LOAD

           filename() as FileName,

           date(date#(mid(filename(), 12, 8), 'YYYYMMDD'), 'DD MM YYYY') as Tr_Date,

           [Sr No],

           [Ac No],

           [Old Ac No],

           [Opening Balance],

           Debit,

           Credit,

           [Closing Balance]

      FROM

      [C:\Users\kyawmyo.tun\Desktop\June For Presentation\Transaction Control\Daily Transfer\DailyTrans_*.xlsx]

      (ooxml, embedded labels, table is [20150601]);

       

       

      Warm Regards,

      Kyaw Myo Tun