2 Replies Latest reply: Aug 3, 2011 6:11 AM by Miguel Angel Baeyens de Arce RSS

    Load multiple CrossTables with same structure

    Thierry Theyskens

      Hi all,

       

      I've a problem regarding the loading of multiple crosstables.

      I have 1 crosstable for 1 sheet.

      These crosstable have the same structure. I already made a loop to load across different sheets but I have a problem.

       

      For example:

      Sheet1 = Mathematics

       

      Name,  Surname, Name of Test1, Name of Test2, Name of Test3

      Nick,Jonhson,12,13,11,

      Ellen, Rob,18,19,10

       

      Sheet2 = Language

       

      Name,  Surname, Name of Test1, Name of Test2, Name of Test3, Name of Test 4,...

      Nick,Jonhson,1,3,3,

      Ellen, Rob,5,5,5

       

      I have no problem to load the first crosstable (of the first sheet) but how can I automate the load of the cross table as the values of "Name of Test" are changing?

       

      Can I have somethink like this?

       

      CROSSTABLE (NameOfTheTest, Results, 2)

      LOAD Name,

                FirstName,

                [Field 1],

                [Field 2]

                ...

      FROM

       

      Thank you for your help