Loading multiple cross tables

[kash04kk]

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

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

NEXT;

[jonathandienst]

Check the table viewer (Ctrl-T) after the load. If the sheets have any differences in the fields (and remember that field names in QV are case-sensitive) then the second table will not be auto-concatenated. Look for a table named T_Data1 or T_Data_1.

[kash04kk]

the sheets have the same fields. after load the table viewer looks like this: