8 Replies Latest reply: Jul 7, 2014 9:17 AM by Matthew Bryant RSS

    Read Loop Element into Column

    Matthew Bryant

      Hi All,

       

      I am loading multiple sheets from an Excel doc into my report, but need to know which sheet the data comes from. This means I need a column in every row with the sheet name. This is what I'm trying, but it doesn't work:

       

      SET i = JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC;

      FOR Each m in $(i);

       

        LOAD

        text('$(m)') as Month,

        A,

        B

         FROM

         [DOC.xlsx]

         (ooxml, embedded labels, Table is [$(m)]);

        

      NEXT

       

      The data loads, but Month is blank on every row. How can I do this?