Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Did you try
CROSSTABLE (NameOfTheTest, Results, 2)
LOAD *
FROM ...
If the first field is always the same, there shouldn't be any problem.
Hope that helps.
BI Consultant
CROSSTABLE (NameOfTheTest, Results, 2)
LOAD Name,
FirstName,
[Field 1],
[Field 2]
...
FROM *.xls
Hi,
Did you try
CROSSTABLE (NameOfTheTest, Results, 2)
LOAD *
FROM ...
If the first field is always the same, there shouldn't be any problem.
Hope that helps.
BI Consultant