11 Replies Latest reply: Jun 30, 2015 3:34 AM by Kashif Feroz RSS

    Loading multiple cross tables

    Kashif Feroz

      Hello everyone,

       

      I am trying to create multiple cross tables. I've an excel file with sheets 2009 and 2010. The header fields in both are same. What is wrong in the below script?? Thanks

       

      for each vSheet in '2009', '2010'

      CrossTable(Description, Data)

      LOAD*

      FROM

      [C:\Badri\Al Ain Ahlia Insurance\AAIC Classwise UW results.xlsx]

      (ooxml, embedded labels, table is $(vSheet));

       

      NEXT;