4 Replies Latest reply: Oct 27, 2015 10:37 AM by bruno bertels RSS

    error field not found / loop on excel sheet/

    bruno bertels

      Hi community

       

      I'am facing an issue with this attached app

       

      This app use an ODBC connexion to loop thru excel sheet.

      Those excel sheet have all the same structure and header and are named by week ( Eg S1 to S43) , by quarter ( Eg T1 to T4) and by month ( janvier fevrier mars)

       

      So a made three script to load tables

      one by week adding the name of the sheet as a dimension "Week" and it works well (table MyTableSem)

      One by quarter adding the name of the sheet as a dimension "Quarter" and it works well also  (table MyTableTri)

       

      Then i wanted to do the same with month sheet

      It's seems to load until the month of August ( Aout in french)

      but i have this message error in the script editor :

       

      I tried to copy past the Aout sheet data to another sheet then renamed it as aout but i have the same error message.

      Of course the sheet named "aout" is existing in the excel workbook.

       

      attached is my qvf app

       

      If someone could have a glance and solve my problem it would be very great.

       

      Thanks in advance